LinkBack URL
About LinkBacks
Hi guys,
Do you have any solution to this,
Asal Benih Grade BC Ket
MPS FARM 1 FARM 1
i want to autofill "asal benih" from the cell "ket".
I already attach a semple
Thanks,,
Autofill with If Formula
Hi guys,
Do you have any solution to this,
Asal Benih Grade BC Ket
MPS FARM 1 FARM 1
i want to autofill "asal benih" from the cell "ket".
I already attach a semple
Thanks,,
Last edited by Sultan1994; 01-05-2023 at 03:46 AM.
Not at all clear!! I have NO IDEA where your results are meant to appear!!
As a starter:
=IFERROR(INDEX($J$3:$J$6,AGGREGATE(15,6,ROW($J$3:$J$6)-ROW($J$3)+1/($K$3:$K$6=$D$3),ROWS(G$3:G3))),"")
WHY should Farm 2 appear TWICE in your expected answer for MIX.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Sorry for my bad explanation,Originally Posted by Glenn Kennedy
Here, I enter the text in G3, G4, G5 and on. when there is just FARM 1 on that cell from G3 to G12 so the cell D3 should automatically write MPS FARM 1, if just FARM 2 it should be MPS FARM 2 and if there is FARM 1 and FARM 2 the text in the D3 shoul automatically write MIX MPS FARM 1 & FARM 2.
Thanks,,
Change both with FARM 1 FARM 2 in J5
"D3"Formula:
Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
but in other case, what if I dont have any table to used as a source of INDEX & MATCH. There is a way the formula work too?Change both with FARM 1 FARM 2 in J5
"D3"Formula:Please Login or Register to view this content.
And in this case, I just want to fill the cell in D3, based on text on G3:G12!
Try this:
=IF(G3="","",IF(AND(COUNTIF(G3:G12,"Farm 1")>0,COUNTIF(G3:G12,"Farm 2")>0),$K$5,IF(COUNTIF(G3:G12,"Farm 1")>0,$K$3,$K$4)))
copy/paste into the other cells.
thanks a lot glenn, you're the best!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks