Hi
I'm completely new to this forum and would love some help on something I'm sure is really simple but I can't get my head around it and can't find what I need on the forum.
I have attached some basic sample data to illustrate:
Thanks v much
Hi
I'm completely new to this forum and would love some help on something I'm sure is really simple but I can't get my head around it and can't find what I need on the forum.
I have attached some basic sample data to illustrate:
Thanks v much
In L6 copied across and down, use this ARRAYED Formula
=IFERROR(INDEX($A$6:$A$23, SMALL(IF($B$6:$B$23= L$5, ROW($A$6:$A$23)-ROW($A$6)+1), ROWS($A$1:$A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
e5=iferror(INDEX($A$6:$C$23,match(E$5&row()-5,$C$6:$C$23,0)+Row()-6,1),"")
and drag across.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
oeldere
you threw an extra +ROW()-6 in there.
@ChemistB
Very good point. I used them for another approach and forget to remove them.
e5=iferror(INDEX($A$6:$C$23,match(E$5&row()-5,$C$6:$C$23,0),1),"")
Here is the updated result (file).
Thanks so much ChemistB and oeldere. You have both solved my problem, and I realise I'm not as stupid as I thought as I would NEVER have figured it out on my own.
Now to ponder why your solutions work....
Thanks again.
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
And if such a method?
Thanks again guys. Have added reputation and solved. I'll be back. You were brilliant.
Thanks also Czeslaw. That looks the most simple solution so far.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks