Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Non-identical but Similar Records
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Non-identical but Similar Records
Try using a pivot table, select the entire worksheet, and, in layout drag
Check #, amount and date buttons to the left side and to the right drag Check # button again. Make sure you see Count of Check # on that button. If not, doble click the button and change from sum to count. Click on finish. When you get the new report, hide the subtotals. You'll be able to get each check once. Just copy and paste the data as value and "give it color" "Lindy" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Non-identical but Similar Records
While waiting for a response, I experimented some more on my own, and arrived
at another solution. I created a formula in an adjacent column: =IF((M3=M2),"dup",""), where M is the column containing check numbers, then filtered for blanks. "Byron720" wrote: Try using a pivot table, select the entire worksheet, and, in layout drag Check #, amount and date buttons to the left side and to the right drag Check # button again. Make sure you see Count of Check # on that button. If not, doble click the button and change from sum to count. Click on finish. When you get the new report, hide the subtotals. You'll be able to get each check once. Just copy and paste the data as value and "give it color" "Lindy" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |