If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|