I'm trying to use a simple array formula to return multiple row matching one criteria but failing miserably.
I have attached a sample- any assistance is much appreciated.
I'm trying to use a simple array formula to return multiple row matching one criteria but failing miserably.
I have attached a sample- any assistance is much appreciated.
so, what are you trying to do exactly? what is failing?
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Cell V59 is the start of the data table I am trying to populate. I want to extract all rows that match the date in V57 and populate the table.
This time with the right file attached...
In C23
=IFERROR(INDEX($C$8:$G$20,SMALL(IF($B$8:$B$20=$B$23,ROW($A$8:$A$20)-ROW($A$8)+1,""),ROWS($A$8:A8)),COLUMNS($B:B)),"")
Enter with Ctrl+Shift+Enter
Copy across and down
Or try a array formula (CSE)
Formula:Please Login or Register to view this content.
I see where I was going wrong. Thanks very much
Try this:
{=INDEX($C$25:$G$35,SMALL(IF($A$25:$A$35=$V$57,ROW($A$25:$A$35)-MIN(ROW($A$25:$A$35))+1,""),ROW(V59)-ROW(V$58)),COUNTA(V$58:$V$58))}
Getting all excited now about array formula...but failing somewhere when I try to introduce multiple criteria. Any help with the attached is much appreciated.
For the multiple criteria try array-entering this modified of your formula.Formula:Please Login or Register to view this content.
Dave
Thanks, Dave. Using your example I think I've got it now!
Good to hear. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks