Delete Non-identical but Similar Records


L

Lindy

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?
 
Ad

Advertisements

B

Byron720

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"
 
Ad

Advertisements

L

Lindy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top