Export to excel show unique values

[emanuelarcas]

Hello,

I have this list exported from SP and contains duplicated values. This list will always contain duplicated data every time is refreshed.
I need to find a solution to have the list with unique values even if it is refreshed.

The remove duplicates and data validation functions is not working for what I need.

Thanks for the help.

Export to excel show unique values

 

[NdNoviceHlp]

A formula solution seems kind of tricky. I'll give U a bump and maybe one of those spreadsheet gurus can whip U up something. Good luck. Dave