Previous Topic Next Topic

Dynamic seletion of rows

Closed
Pedda - Mar 6, 2009 at 03:25 AM
 Pedda - Mar 6, 2009 at 04:56 AM
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

Answer 1 / 2
Tweedledum Posts 181 Registration date Monday January 19, 2009 Status Member Last seen April 2, 2009 125
Mar 6, 2009 at 03:45 AM
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
Answer 2 / 2
Pedda
Mar 6, 2009 at 04:56 AM
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.

Similar discussions

Sir in dynamic duo point is not increasing why
Aryan -
dwebb -

1 response
How to add Rows automatically based on Cell Value In Excel?
Raj_2823 -
TrowaD -

7 responses
Insert multiple copied rows at fixed intervals
gizework -
gizework -

9 responses
macro for inserting multiple rows between data
vba dummy -
TrowaD -

1 response
Converting rows of data in notepad to columns
Need help -
Philgood_FR -

2 responses