The Cellar - View Single Post

Shawnee123 · 09-25-2009, 12:30 PM

I needed to find duplicate SSNs in an Excel spreadsheet WITHOUT having to delete the dupes (which is the only way I could find to do it within excel itself) because I need to find which ones were erroneously reported twice to the feds. There's an add-on, for which I got a free trial. I am able to just color the rows of the duplicate IDs. I love it.

NOW I need to sort these colored rows out and combine back into another spreadsheet. There's an add-on for THAT, too. No free trial.

Does anyone know if Excel 2007 (can you believe I still have Office 03 at work...sheesh) has these capabilities because if so I'm going to copy the whole damn thing to a thumb drive and work on it at home where I have software from this damn decade.

grumble grumble

09-25-2009, 12:30 PM	#1968
Shawnee123 Why, you're a regular Alfred E Einstein, ain't ya? Join Date: Jun 2006 Posts: 21,206	I needed to find duplicate SSNs in an Excel spreadsheet WITHOUT having to delete the dupes (which is the only way I could find to do it within excel itself) because I need to find which ones were erroneously reported twice to the feds. There's an add-on, for which I got a free trial. I am able to just color the rows of the duplicate IDs. I love it. NOW I need to sort these colored rows out and combine back into another spreadsheet. There's an add-on for THAT, too. No free trial. Does anyone know if Excel 2007 (can you believe I still have Office 03 at work...sheesh) has these capabilities because if so I'm going to copy the whole damn thing to a thumb drive and work on it at home where I have software from this damn decade. grumble grumble __________________ A word to the wise ain't necessary - it's the stupid ones who need the advice. --Bill Cosby