# extract data from list on the basis of multiple criteria

1. ## extract data from list on the basis of multiple criteria

Hi,
Pls find an attachment of file which contains list & required result

actually the list is ongoing increasing, so I want to fetch the records from total list on multiple criteria, I don't want to create table for the list.
Sr is unique value

As well as please specify how i can get marks too of same record  Register To Reply

2. ## Re: extract data from list on the basis of multiple criteria

Please try at G4 copy to H4 and copy down

=IFERROR(INDEX(A:B,AGGREGATE(15,6,ROW(A\$4:A\$99)/(\$B\$4:\$B\$99=\$H\$2)/(\$C\$4:\$C\$99>=\$I\$2)/(\$C\$4:\$C\$99<=\$J\$2),ROWS(G\$4:G4)),COLUMNS(\$G4:G4)),"")  Register To Reply

3. ## Re: extract data from list on the basis of multiple criteria

It's a wonderful
but I am sorry that actually the Sr is after marks column i.e. in 3rd column & in sample file I have put it in 1st column...  Register To Reply

4. ## Re: extract data from list on the basis of multiple criteria

Please try at F4 and copy down

=IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW(C\$4:C\$99)/(\$A\$4:\$A\$99=\$G\$2)/(\$B\$4:\$B\$99>=\$H\$2)/(\$B\$4:\$B\$99<=\$I\$2),ROWS(F\$4:F4)),COLUMNS(\$F4:F4)),"")

or F4:G4 and copy down
=IFERROR(INDEX(\$B:\$C,AGGREGATE(15,6,ROW(C\$4:C\$99)/(\$A\$4:\$A\$99=\$G\$2)/(\$B\$4:\$B\$99>=\$H\$2)/(\$B\$4:\$B\$99<=\$I\$2),ROWS(F\$4:F4)),3-COLUMNS(\$F4:F4)),"")  Register To Reply

5. ## Re: extract data from list on the basis of multiple criteria

Both formulas working fine ....

Thank you so much... it's nice  Register To Reply