Filter unique records only: Want the last records, not the first

[davelarue]

Hello,
I have a column of numbers, where some are duplicated.
The 'filter unique records' feature gives us the first entry of a duplicate.
Is there any way to make Excel choose the last duplicate instead?
Thanks,
David

[martindwilson]

insert 2 new columns(or add at end)
assuming your numbers are in col A with a header
in your first new column say B put in row 2 (b2)
=COUNTIF($A$2:A2,A2) and drag down to end of list
now in next column say C in C2 put
=B2=MAX(($A$2:$A$1000=A2)*($B$2:$B$1000)) (change range to match length of data) and confirm with ctrl+shift+enter
and drag down
tyouou can now filter on TRUE

BUT.........
now ive said all that try instead
in a spare column in row 2 enter 1
in row 2 enter 3
select both
and drag down to end of your numbers
so each row is numbered 1,2,3,4...........
now select sheet and sort descending on that column
now list will be upside down
filter on unique will now return the last entry, job done!