Excell - how can I find duplicated cells?

Question

I am doing a report with sale order numbers, I have about 100 lines. Each lines has the sales order number, p.o#, prices, dates exc... what excell tool can help me find duplicate lines? please help.

thanks...

Answer 1

MAKE A BACKUP OF YOUR SPREADSHEET.

Highlight your data, the on the toolbar click on Data>Sort.

In the dialogue box click on the headers checkbox to make sure the headers are removed from the selection.

From the drop down box choose the column you want to sort on, then ok.

This'll put the list into numeric order. Let's assume all your data is in Columns A to D and the sales orders are in column A. Sort on column A to get everything in numeric order, as detailed above.

In Cell E2 type =if(A2=A1,"Duplicate","")

Fill this formula down your list.

You could also put a filter on all of the data, including the duplicates columne and filter on the "Duplicate"

Answer 2

sort the sheet on the column that you are looking for dupes

then in the column next to it put an if statement seeing if the line above it is the same

if (b2=b1,0,1)

then just look where it = 0 then you see all the dupes

or you can cut and paste that column to the column next to it  saying paste special (values only)  and sort by that column  and all of the dupes will sort to the top