+ Reply to Thread
Results 1 to 2 of 2

Hiding recurring results?

Hybrid View

  1. #1
    Registered User
    Join Date
    12-21-2011
    Location
    EU here and there
    MS-Off Ver
    Excel 2019
    Posts
    70

    Hiding recurring results?

    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 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.

    uaImV.png

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Hiding recurring results?

    Assuming your data starts in C1, select your range of cells and activate C1, then your conditional format formula is:
    =IF(COUNTIF($A$1:A1,"="&A1)>1,TRUE,FALSE)
    and assign the font to white if true.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Hiding formula results
    By controlfreak in forum Excel General
    Replies: 3
    Last Post: 06-12-2012, 07:49 AM
  2. Hiding #N/A results from V-Look Up Formula
    By JWR in forum Excel General
    Replies: 2
    Last Post: 11-19-2009, 04:28 PM
  3. pivot tables hiding zero results
    By zeek in forum Excel General
    Replies: 3
    Last Post: 04-03-2008, 06:11 PM
  4. hiding blank cells when no results
    By andyell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-14-2006, 11:00 AM
  5. Hiding Expression Results...
    By bartinpc in forum Excel General
    Replies: 3
    Last Post: 06-12-2005, 02:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1