Removing Duplicates From a query with conditions

[agatina11]

Hi,

could you please help with a question regarding excel queries?

I've got a query where I'd like to remove duplicates from ( name of the supplier), however I want to do it only for each week, not for the whole file.

Is there a way?
Thanks
Agata

 

[JPARKHURST]

Hi,

could you please help with a question regarding excel queries?

I've got a query where I'd like to remove duplicates from ( name of the supplier), however I want to do it only for each week, not for the whole file.

Is there a way?
Thanks
Agata

Macro or formula?