How can i extract different invoice numbers on an Invoice Consolidation sheet

Help
, , , , ,
1

Hi,

I have an invoice sheet in excel with a consolidated invoice sheet that has single invoices against multiple purchases made. These invoices i receive on a monthly basis. I also have daily invoices coming in.

I want to get a distinct list from the Monthly consolidated invoice sheet and loop through to check if i have it on my daily invoice sheet. If it is not i want to update inv_daily with the details of the invoice number.

Best,
Saafiyah

Invoices
Invoices428Ă—516 5.77 KB

2

Have a look into this.

1 Like
3

thank you, so i got the distinct list but it didn’t remove the duplicates

4

Hi @adamssaafiyah

You want to get the distinct list and also remove duplicate invoices? please mention the requirement exactly.

5

yes please, i apologies. i want to get a distinct list( i did so by using an assign = dt.DefaultView.ToTable(true, “InvoiceNumber”) and now i want to remove the duplicates in that row. i thought that would remove the duplicates

6

find some starter help here:
FindDupsUniquesFirstFromGroup_By1Col.xaml (8.0 KB)

1 Like