Hello, I want to Filter data from a table based on two criteria and show few data fields in different table. See attached excel with sample data.
Thank you in advance
Hello, I want to Filter data from a table based on two criteria and show few data fields in different table. See attached excel with sample data.
Thank you in advance
Please try at
A15
=IFERROR(INDEX($A$1:$A$9,AGGREGATE(15,6,ROW($A$2:$A$9)/($F$2:$F$9=$K$1)/($I$2:$I$9="Yes"),ROWS(A$15:A15))),"")
B15:E15
=IF($A15="","",VLOOKUP($A15,$A$2:$E$9,COLUMNS($A15:B15),))
Format C15:E15 to Time
I am finding it very difficult to replicate in other spreadsheet when the location of table changes. Is there any simpler way of doing this ?
Are you still using Excel 2010 or something newer?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I’m using 2013
Please update your user profile - it's out-of-date. Thanks.
Any simple solution ?
You won’t get anything simpler than what you have already been offered.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks