| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Select rows based on criteria
Hello,
i have a worksheet with data (numeric,text) from the A collum up to the AH each row is a new data entry, (sometimes i have up to 2500 entries) so i need to find out, how i can with some criteria such as <if the value at the cullum V is above 110 for example then give me all the row in a new worksheet inside the same xls file. It is tricky for me to do that... i have good hadling of the if command and the option to make an auto filter is not the goal.... the logic is that i want to do that in a kind of auto... thank you for your help in advance Sotiris S |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dragging to select multiple rows causes out of control scroll | Excel Discussion (Misc queries) | |||
| Select rows and sort based on type | Excel Discussion (Misc queries) | |||
| Select Rows dependant on certain field data | New Users to Excel | |||
| Is it possible to use the sumif function based on the criteria of. | Excel Worksheet Functions | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Threaded Mode
