Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reporting Highest Values
I've got a worksheet, c 200 rows, with data in Cols A to L (range name
"Data") where Column L (range name "Result") has a series of variable numeric values. I want to create a new worksheet that reports just those rows that satisfy a variable criteria (single cell with range name "criterion"). That is - report all rows in "Data" range where the "Result" value is, eg, greater than or less than "criterion") value Can SKS help me to do it Tx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REPORTING unique values | Excel Worksheet Functions | |||
Looking up and reporting values across tabs | Excel Worksheet Functions | |||
Reporting multiple values within a cell | Excel Discussion (Misc queries) | |||
3 highest values | New Users to Excel | |||
3 highest values indicated using formatting | Excel Worksheet Functions |