So I have a crazy list of value, some of witch appear too many times. Problem is that there are duplicate values witch need to be there, and dublicates that don't. I hava to compare different columns and remove the cells containg extra info. also problematic is that you can't tell witch column contains the dups. Let me demonstrate:
1 1 1 ===>1 1 1
1 2 2 ===>2 2 2
2 2 2 ===>2 2 2
2 3 3 ===>3 3 3
3 4 3 ===>4 4 4
4 5 4 ===> 5 5 5
5 5 5
My goal is to get the matching value in the same row. If every column has the duplicate (or triplicate) value then it needs to be there. If if doesen't exist it need to be gone
Bookmarks