Creating a report to filter out duplicates on daily basis

[jlopez3565]

Hi all,

I'm relatively new to this project I've been presented with. There is a spreadsheet that I receive daily that has about 600-1k lines of certain shipments that are not released. Since this is sent daily, it's been hard for me to keep up as duplicates show up when certain issues are not resolved to remove it from the spreadsheet.

I created a database on Microsoft Access to cancel out some of the duplicates, but it's gotten to the point that the data is overflowing with duplicates and it's quite overwhelming. It may just be me and my frustration, but..

My question: Is there a way I can group all these together, remove the duplicates and continue to do it on daily basis without having to use the Microsoft Access database? I've attached a copy as a reference. Any help is greatly appreciated.

[sandy666]

Something like this with PQ?

[jlopez3565]

This looks great, but for example, if you look at the first PO_NBR 1400634 it shows up 3 times. I've tried the COUNTIF formula - even =sumproduct(1/countif(dat,dat)) and it won't single out the duplicates.

[sandy666]

no, because Aging is :
7
6
5
there is no duplicated rows
Filter PO_NBR by 1400634 and check Aging

[jlopez3565]

I didn't even consider that, Thank you! I guess I can record a macro to start getting rid of all the duplicates. Any suggestions on a faster way? By the way - I appreciate the help, Sandy. It's life saving.

[sandy666]

PQ automatically remove duplicates.
After PQ you can use PT to create a report of the type you want

If that takes care of your original question, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. Thanks.

[jlopez3565]

Glorious! Will do - Thanks again, Sandy!

[sandy666]

You are welcome, thanks for the feedback and mark thread solved jump.gif