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

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?