archwayguy
Technical User
I'm not a pro in programming in the least bit, in fact, I know nothing about it. I have a script I found on the net that will take two columns in Excel and filter all duplicates to only show unique cells in either column. Now I need something that will do the exact opposite but with multiple columns. I need this to tell me what is a duplicate in more than one column. The script I currently have is ran by just drag-and-drop the Excel file onto the .vbs and then it creates a new sheet in the Excel workbook. It can be found here: Any helpers that can tell me how to fix this to my liking or could do so for me? Here is another link I found for conditional formatting that does what I am looking for, but is there an easier way to do this?