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

Dynamic seletion of rows
How to paste data in alternate rows in excel - Excel Forum
How to automatically copy rows in excel to another sheet based on criteria ✓ - Excel Forum
How to delete rows in word - Guide
How to convert rows into columns in notepad++ ✓ - Excel Forum
How to repeat rows a specified number of times based on another column in excel - Guide

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

Copy row and insert n times

Duplicate rows based on cell value

How to add Rows automatically based on Cell Value In Excel?

Code to move rows into another sheet based on certain values

Similar discussions

Subscribe To Our Newsletter!