Hiding recurring results?

[johanna0507]

Hi all -
Hope somebody can help with how to hide repeated values in a column, and only display them ONCE.

Please see attachment. The names are in column "C" and the grey bar, where the name first occurs, is not using any formula, just hardcoded.

I want to apply conditional formula or something like that, to keep the names as they are, in the grey bar, but supress the names in the subsequent rows, if they are repetitions.

Attachment 274784

[DBY]

Hello
You could perhaps use two CF formulas. For example if your range of values was in C2:E20:

=COUNTIF($C$2:$C2,$C2)=1

would highlight selection were the name first occurs. The second applied only to C2:C20:

=COUNTIF($C$2:$C2,$C2)>1

would hide the duplicate values. With both you would obviously have to choose the formats you require. Grey fill, white font etc.

Hope this helps.
DBY

[johanna0507]

Hello
You could perhaps use two CF formulas. For example if your range of values was in C2:E20:

=COUNTIF($C$2:$C2,$C2)=1

would highlight selection were the name first occurs. The second applied only to C2:C20:

=COUNTIF($C$2:$C2,$C2)>1

would hide the duplicate values. With both you would obviously have to choose the formats you require. Grey fill, white font etc.

Hope this helps.
DBY

Thanks DBY! I am almost there, but there is a remaining problem:

I formatted the column to have "No" background and White fonts.
I then applied the first suggestions and set =COUNTIF($C$17:$C17,$C18)=1 to apply to all values in the column.
This sets the first instance of the name to have grey background and black fonts which is what I wanted.

However the formula it also hides the names that occur only once. I don't want that!
They should have the same formatting as the other headers, even if they only occur once.

I can't figure out how to prevent that, or construct a Conditional format that sets these names back to the formatting I want.

[johanna0507]

Oh I figured it out: =COUNTIF($C$17:$C17,$C18)=1

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.