Forum Discussion

Copper Contributor

Oct 08, 2020

How to find and highlight duplicate values in a excel column using powershell

I have duplicate values in a excel column. I want to find those duplicate values and highlight them with any color. I want to do so using powershell as I have many excel files. I can see that there i...

Macros and VBA

NikolinoDE

Gold Contributor

Oct 08, 2020

SamWhite

Maybe this VBA solution will help you.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Mappe3_TEST3.xlsm20 KB

SamWhite
Copper Contributor
Oct 08, 2020
NikolinoDE Thanks, please suggest how to do the same via powershell
- NikolinoDE
  Gold Contributor
  Oct 09, 2020
  SamWhite
  As for powershell, I'm sure not the right one.
  Sry but here has to be someone else who is familiar with powershell.
  I'm not even sure whether your question will be answered here in the Excel forum, maybe in another forum here in the community.
  
  Thank you for your patience and time and sry that I could not give you a useful solution.
  
  Wish you a nice day / night with health and joy.
  
  Nikolino
  I know I don't know anything (Socrates)
  - SamWhite
    Copper Contributor
    Oct 10, 2020
    NikolinoDE Can you explain me the logic you used in the macro? Also I cannot find enough documentation on it, but do you know how to use the xldupeunique as described in the link below:
    
    https://docs.microsoft.com/en-us/dotnet/api/microsoft.office.interop.excel.xldupeunique?view=excel-pia