Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I use spreadsheets that list payments by check number, but each check number
and amount is repeated multiple times, once for every voucher that is paid on that check. I want to keep only one record per check number, since all I care about is the check number, amount and date. Techniques for filtering unique records don't work because the multiple entries against each check number are each unique because they reference different vouchers. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete records when certain records have duplicate column data | New Users to Excel | |||
Quick way to elimate BOTH identical records? | Excel Discussion (Misc queries) | |||
Merging slightly similar records | Excel Discussion (Misc queries) | |||
Finding and Highlighting Similar but not Identical Cells in a Colu | Excel Discussion (Misc queries) | |||
getting unique records similar to the primary key in access | Excel Worksheet Functions |