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
Arrange all the data into a single table and sort by score.
Last edited by shg; 09-01-2009 at 07:07 PM.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
96 tables? and you could be in any one of them?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
@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...
thats a tall order for a function i suppose someone could code if for you to loop through all values on all sheets and return marks/ names/id's tho
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks