searching specific columns

**koolflame** · 09-01-2009, 04:51 PM

hello

i have attached a screenshot of an excel file which was converted from pdf. it contains result of a medical addmission test and has some 96 tables. i scored 424 marks in the test. now i want to search the columns named 'marks' in all the tables for the values that are greater than or equal to '424' so that i can know how many candidates have a higher merit than me. the values returned should contain ID. # and name along with marks of all the candidates having marks greater than or equal to '424'.

fahad kamal

**shg** · 09-01-2009, 05:12 PM

Arrange all the data into a single table and sort by score.

**martindwilson** · 09-01-2009, 05:37 PM

96 tables? and you could be in any one of them?

**koolflame** · 09-01-2009, 07:04 PM

@martindwilson

i know where i am in the tables. but i want to search all the candidates who have scored 424 marks or above that. i want a list of those candidates. and i want all tables to be searched for the data i am looking for...