Excel Listing

  osben 15:59 01 Apr 2007
Locked

Hi

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 2007

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

=IF(COUNTIF(A$1:A$10, A1)>1,TRUE,FALSE)

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 2007

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 2007

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 2007

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.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

HP’s new Surface Pro rival is designed specifically for Adobe-using designers and artists

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?