Hi all,
I'm an excel novice and I'm trying to find a way for the following formula to only display visible results from the original data source.
The scenario - I'm trying to list the names of anyone that meets a certain criteria (exam grade), but then I also want to filter by age so that list only displays people (for example) who are 45 - 50 years old. I'm assuming it's a subtotal I need to input?
Current formula
=IFERROR(INDEX(Table1[Name],SMALL(IF(Table1[Exam Grade]="Level 1",ROW(Table1[Name])- MIN(ROW(Table1[Name]))+1),ROWS(B$5:B6))),"")
N.B. this formula currently works at listing names of those who have achieved a level 1 exam grade.
Any help is greatly appreciated!!
Bookmarks