Dynamic seletion of rows

Closed
Pedda - 6 Mar 2009 à 03:25
 Pedda - 6 Mar 2009 à 04:56
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 responses

Tweedledum Posts 181 Registration date Monday 19 January 2009 Status Member Last seen 2 April 2009 125
6 Mar 2009 à 03:45
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
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.