Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i filter records with greater number across rows
I have a worksheet with 9 columns and 1883 rows. My main focus is on column b
and c. Column b has file numbers and column c has the file revision numbers. I want to see only data with the latest file revision across the data range. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i filter records with greater number across rows
Hi,
select the 9 columns and then filter it by column C, descending so you will have the latest one at the beginning Hope this help "Scouvy" wrote: I have a worksheet with 9 columns and 1883 rows. My main focus is on column b and c. Column b has file numbers and column c has the file revision numbers. I want to see only data with the latest file revision across the data range. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get Auto filter to report number of records filtered? | Setting up and Configuration of Excel | |||
Number of records after filter | Excel Worksheet Functions | |||
how do i filter a list greater than 1000 rows | Excel Discussion (Misc queries) | |||
Advanced Filter: Number of Records Found | Excel Discussion (Misc queries) | |||
How do I show number of records that meet criteria filter | Excel Discussion (Misc queries) |