I need to find a way to find duplicate values of two column, but let me explain a bit more
In column B i have a list of invoices and column c is the line number of an invoice. then in column L i have the value
I have records where there are duplicate invoices(b) and lines(c) but the value(L) is different
Example:
(B) (C) (L)
1957286 1 9.45
1957286 2 1.33
1957286 3 1.33
1957286 4 1.05
1957286 6 49.92
1957286 7 7.00
1957286 7 7.00
1957286 7 9.80
1957286 7 20.30
1957286 7 29.50
1957286 7 38.50
As you can see there is invoice(B) 1957286 and line(C) 7 duplicated 6 times, I would need to delete 5 of them leaving the highest value(L) 38.50
so the report would look like this afterwards
Example:
(B) (C) (L)
1957286 1 9.45
1957286 2 1.33
1957286 3 1.33
1957286 4 1.05
1957286 6 49.92
1957286 7 38.50
I have 1000's of rows every month I have to do this with, everyone else has been doing it manually, I want to automate it and save hours of work.
Thanks for your help.
Maybe make a 2 step process if possible where it highlights the rows it wants to delete, and then after quick manual review and verified that is correct it deletes them?
In column B i have a list of invoices and column c is the line number of an invoice. then in column L i have the value
I have records where there are duplicate invoices(b) and lines(c) but the value(L) is different
Example:
(B) (C) (L)
1957286 1 9.45
1957286 2 1.33
1957286 3 1.33
1957286 4 1.05
1957286 6 49.92
1957286 7 7.00
1957286 7 7.00
1957286 7 9.80
1957286 7 20.30
1957286 7 29.50
1957286 7 38.50
As you can see there is invoice(B) 1957286 and line(C) 7 duplicated 6 times, I would need to delete 5 of them leaving the highest value(L) 38.50
so the report would look like this afterwards
Example:
(B) (C) (L)
1957286 1 9.45
1957286 2 1.33
1957286 3 1.33
1957286 4 1.05
1957286 6 49.92
1957286 7 38.50
I have 1000's of rows every month I have to do this with, everyone else has been doing it manually, I want to automate it and save hours of work.
Thanks for your help.
Maybe make a 2 step process if possible where it highlights the rows it wants to delete, and then after quick manual review and verified that is correct it deletes them?