Excel query

  freddy-firecracker 18:45 24 Jun 2008
Locked

Hi

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.


FF

  irishrapter 19:11 24 Jun 2008

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

  VoG II 21:39 24 Jun 2008

.

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

=COUNTIF(B:B,A1)>0

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

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

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

HomePod review

Streaming : Netflix ou Amazon Prime Video ?