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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reporting Highest Values
BRob,
Select your data, then use Data / Filters.. Autofilter Select the dropdown at the top of column L, select Custom, and then set your criteria. Select your data table again after the filter has been applied, then copy and paste in a new sheet. The visible cells only should be copied - if you get all the cells, used Edit / Go To... Visisble cells only OK prior to copying. HTH, Bernie MS Excel MVP "BRob" wrote in message ... 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 |
Reply |
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 |