Excel Listing

  osben 15:59 01 Apr 07


Using excel XP Pro

Have a list of names in one column.

Is there any way I can do a search on the column and get a list of names thrown up that have been duplicated. The search facility seems to be a bit limited.

Many thanks

  VoG II 16:19 01 Apr 07

Say your list is in A1:A10. Highlight A1:A10, Format > Conditional Formatting. Change 'Cell Value Is' to 'Formula Is' and in the formula box enter


then click the Format button and select e.g. a red font. OK your way out. Duplicates should now be in red.

  Chris the Ancient 16:30 01 Apr 07

An interesting thought came up here.

VoG™ (and I) are great lovers of ASAP utilities which is a free 'add-in' which has loads of useful menu-selectable extras of useful routines. There is a selectable 'delete duplicates' in a range - but no simple command to just highlight them!

To others reading this thread, I (and VoG™ - I hope) thoroughly recommend ASAP utilities available from...

click here

  VoG II 16:40 01 Apr 07

Yes, Chris - ASAP Utilities is excellent.

I'm still finding my way around Excel 2007 but I've just found that Conditional Formatting on the Home menu allows easy highlighting of duplicates. Similarly there is an option on the Data menu to remove duplicates.

  Chris the Ancient 16:57 01 Apr 07

Now that I call useful!

Perhaps one day I'll be able to afford all the upgrading :-(

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5