Parsing / Reordering Data for Easy Duplicate Finding?

**bikeking8** · 04-27-2013, 07:17 AM

I have a spreadsheet with tens of thousands of lines. Attached is what I need to do; basically I need to find departments that have duplicate permission "sets". If the raw data I have was formatted differently, it could have been much easier but I'm stuck dealing with what I got. In the attachment you can see what my approach is. If anyone can either tell me how to do that without having to manually copy-paste cells for days on end OR if there's a better way to find the departments with duplicate permission sets, please help!

**Lemice** · 04-27-2013, 07:32 AM

Hello,

Try this sample file. All you have to do is drag the formula on J17 to O17 down until you see lots of blank. This is what it does:
- Column J, get all the unique name from Department, then
- Column K, L, M and N will get the corresponding data.
- Column O will check if it's unique. FALSE means it's duplicated.