# 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

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)),"")

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...

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)),"")

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

Both formulas working fine ....

Thank you so much... it's nice

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1