Dynamic seletion of rows [Closed]

Report
-
 Pedda -
Hello,
I need to select the entire row based on cell value.
Ex: Students and marks is avialable in one excel sheet. I need to display the students whose having less than 60% of total marks.

Thanks,
Pedda

2 replies

Posts
181
Registration date
Monday January 19, 2009
Status
Member
Last seen
April 2, 2009
124
If the marks are in percentage for it would be the VLOOKUP function, you could put the 60% into another cell and reference it with a less then sign. I think that woudl work pretty well, percentages might have to be on the left of the students name instead of the right i though
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

I need to the records by percentage or by student name. some less than grater than also required. Is it possible to write more than one VLOOKUP for one cell.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!