| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to filter list based on multiple criteria
Date S/No Name Dept R/No
26/07/09 01 ABC M1 M001 26/07/09 02 DEF S1 S001 26/07/09 03 GHI A1 A001 27/07/09 04 DEF S1 S001 27/07/09 05 ABC M1 M001 27/07/09 06 GHI A1 A002 I have a long list of records as shown above, how can I copy the list to another range with records for "Name", "Dept" and "R/No" not duplicated and showing the latest S/No. In other words, Record 1 and Record 2 should not appear as it is duplicated in Record 5 and Record 4 respectively. The new list should only shows: Date S/No Name Dept R/No 26/07/09 03 GHI A1 A001 27/07/09 04 DEF S1 S001 27/07/09 05 ABC M1 M001 27/07/09 06 GHI A1 A002 Thanks for any help i can get. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query criteria based on a changing criteria list | Excel Discussion (Misc queries) | |||
| Copying data based on filter criteria | Excel Worksheet Functions | |||
| Run Filter criteria based on data in range | Excel Discussion (Misc queries) | |||
| Separating a List onto multiple worksheets in the same workbook based off 1 criteria | Excel Worksheet Functions | |||
| filter or format based on criteria in more than one column | Excel Worksheet Functions | |||
Threaded Mode
