Suppressing Duplicates

[mason1234]

I have a worksheet that has duplicate entries in several columns, for example, the first column is for "School" and the name of a school repeats many times until it gets to a record on down the list for a different school name. Is there a way to make it so that after the first entry of a school the following cells in that column won't show anything until a new value appears? Thank you.

[Steve Hartman]

You could use conditional formatting. Select the second cell in the column (say A2), then Format > Conditional formatting. Choose formula is and enter the formula =A2=A1. Click on format and make the font color white. Click Ok twice to exit. Copy the cell and paste special > format down your column.

[Russell Hauf]

On 2002-02-19 16:19, mason1234 wrote:
I have a worksheet that has duplicate entries in several columns, for example, the first column is for "School" and the name of a school repeats many times until it gets to a record on down the list for a different school name. Is there a way to make it so that after the first entry of a school the following cells in that column won't show anything until a new value appears? Thank you.

Yes, use conditional formatting. Select your entire column (say A1 to A100), and go to Format-Conditional Formatting. Then select "Formula Equals", and in the formula box, type:

=(A1000=A999)

Use the last and second to last rows, it makes a difference. (or don't select the first row and put =(A2=A1)). Then format the font to white (if your background is white).

Hope this helps,

Russell

[Derek]

Mason
If your school list is in column A, starting at A4, put this formula in B4 and scroll down. This will then only display unique entries.
=IF(ISNA(VLOOKUP(A4,$A$2:$A3,1,FALSE)),A4,"")
Derek

[mason1234]

Derek, Russell and Steve,

Thanks so much! I have tried and these work marvelously. I really appreciate your help. Thanks!

Merle Mason