View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Bryan Hessey
 
Posts: n/a
Default How to blank out cells with duplicate values?


Select cell A1, then select the A column (check that A1 is the active
cell, the odd highlight)
Format, Conditional Format, Formula is
=COUNTIF(A$1:A1,A1)<1
and set font colour to White (on white)

duplicates are then hidden

Hope this helps

--


Dominic Wrote:
Bleu,

You could do this using a helper column I believe.

Insert a column next to your order number column. Then beginning with
the
second row type the formula =IF(A2="","",IF(A2=A1,"",A2)). Copy this
formula
down the column.
Where column A is the column your order numbers are in.

Then copy the column, the paste:special:values over the top.

Is that what you are looking for?

"Bleu_808" wrote:

Bob, Thanks - but this did not work for me. Let me explain a little
better...

ex:
1234 Part #1
1234 Part #2
1234 Part #2
1234 Part #4


4321 Part #1
4321 Part #2
4321 Part #3


6789 Part #1
6789 Part #2

I still want to view the informationon the rest of the row that has
the duplicate number, I just want to clear only the cell of the
duplicate.

Sorry if I wasn't clear :)

Bleu




--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=537895