Forum Home
Press F1
Thread ID: 128897	2013-01-22 09:19:00	Excel formula needed	WayneMiddy (14028)	Press F1

Post ID	Timestamp	Content	User
1324310	2013-01-22 09:19:00	I have a spread sheet with around 150 rows of surname in Col A and first name in Col B over in Col M i have added ColA & Col B together eg SmithJohn Now i need to check if any of the names in the 150 rows are repeated. Ideal if the name in Col A & B were highlighted or changed colour if possiable. we are just looking for any repeats in Col M Hope this makes sence. TIA wayne	WayneMiddy (14028)
1324311	2013-01-22 09:34:00	One way http://howto.mellowcart.com/ Another way from Brainy box son ----- Select the Col - Conditional Formatting - Highlight cell rules- Duplicate Values - Click the drop down box to select the colour you want duplicates to show.	wainuitech (129)
1324312	2013-01-22 09:52:00	Add to above -- the example pictures Taken from office 2013, but 2007 & 2010 are the same way: 4688 4689 Had to use a different Computer to upload the pics, the PF1 unloader doesn't like IE10.:mad:	wainuitech (129)
1324313	2013-01-22 18:55:00	Thanks wainuitech that works great.	WayneMiddy (14028)
1324314	2013-01-22 20:04:00	You coud also just enable filtering on the title row and sort by name - would be very easy to see duplicates then as they'd be in adjacent cells. I'll have to try and remember that conditional formatting trick, I often have to search through large sorted spreadsheets looking for duplicates and I've always added a column and used a formula like =IF(B3=B2,"!","") to mark the duplicates. I also have to check for gaps in a numerical sequence to show missing rows and I've used =IF(B3-B2<>1,"!","")	dugimodo (138)
1