Remove Duplicate rows based on week number

[Elliottj2121]

Hello

I am wondering if anyone can help me with this problem. I have a spreadsheet with about 10,000 rows and I want to remove duplicate customers that fall within the same week number. Note that some customers have the same name but different account numbers as shown with Alpha Co. Thank you in advance!!!

Here is a representative sample of the raw data:

Week Num	DATE	Customer Number	NAME	Credit Manager	Year
23	6/1/2022	100	Alpha Co	Bob	2022
23	6/1/2022	900	Alpha Co	Bob	2022
23	6/1/2022	101	Beta Co	Jim	2022
23	6/1/2022	101	Beta Co	JIm	2022
23	6/1/2022	102	Delta Co	Tom	2022
23	6/1/2022	103	Echo Co	Judy	2022
23	6/1/2022	104	Foxtrot Co	Bob	2022
23	6/1/2022	105	Golf Co	Tom	2022
24	6/6/2022	100	Alpha Co	Bob	2022
24	6/6/2022	900	Alpha Co	Bob	2022
24	6/6/2022	101	Beta Co	Jim	2022
24	6/6/2022	101	Beta Co	JIm	2022
24	6/6/2022	102	Delta Co	Tom	2022
24	6/6/2022	103	Echo Co	Judy	2022
24	6/6/2022	104	Foxtrot Co	Bob	2022
24	6/6/2022	105	Golf Co	Tom	2022

And here is what I am looking for:

Week Num	DATE	Customer Number	NAME	Credit Manager	Year
23	6/1/2022	100	Alpha Co	Bob	2022
23	6/1/2022	900	Alpha Co	Bob	2022
23	6/1/2022	101	Beta Co	JIm	2022
23	6/1/2022	102	Delta Co	Tom	2022
23	6/1/2022	103	Echo Co	Judy	2022
23	6/1/2022	104	Foxtrot Co	Bob	2022
23	6/1/2022	105	Golf Co	Tom	2022
24	6/6/2022	100	Alpha Co	Bob	2022
24	6/6/2022	900	Alpha Co	Bob	2022
24	6/6/2022	101	Beta Co	JIm	2022
24	6/6/2022	102	Delta Co	Tom	2022
24	6/6/2022	103	Echo Co	Judy	2022
24	6/6/2022	104	Foxtrot Co	Bob	2022
24	6/6/2022	105	Golf Co	Tom	2022

 

[DanteAmor]

Hi @Elliottj2121 . Thanks for posting on MrExcel board.

Use the excel functionality to remove duplicates:

1. Select your data..

2. On the Data tab, in the Data Tools group, click Remove Duplicates.

The following dialog box appears.

3. Mark the Week num and Custom Number columns:

4. Click OK

I hope works for you.
Have a nice day
Dante Amor
----- --

 

[Elliottj2121]

Thank you! I tried that first but didn't unselect the non relevant ones! Worked great!