Excel query

  freddy-firecracker 18:45 24 Jun 08


I have two lists of numbers, one in column A which has 3000 odd entries, the other in column B with approx 1000 enrtries which were randomly selected from the list in column A. I am looking for a way of showing what numbers appear in both columns which will then allow me to see what numbers only appear once.

Any help is appreciated.


  irishrapter 19:11 24 Jun 08

Try using conditional formatting to change the colours of all duplicate cells.

  VoG II 21:39 24 Jun 08


Select column A. Format > Conditional Formatting. Select Formula Is. Enter the formula


Set your format (e.g. colour cells red) and OK your way out.

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

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…