+ Reply to Thread
Results 1 to 3 of 3

Hide some duplicate dates with conditional format

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2010
    Posts
    48

    Hide some duplicate dates with conditional format

    I,m trying to use conditional format to hide some duplicate dates from Col A. (see attached)- Column A has "dates", Col B is "bookings", Col C is "tasks".
    My first condition is that if there is txt in Col B "Bookings" then Col A "Dates" will always remain visible (duplicated or not.)

    I want a formula to remove duplicate dates from Col A on the condition that if there is txt in Col C , but I want the first duplicate to remain visible and the rest is to be hidden.

    (NB: If there is txt in Col B,there is not txt in Col C, and visa versa, so the txt is in B OR C, not both).

    I have tried to use the fomula =AND(COUNTIF($A$2:$A2,$A2),$C2<>"") and this hides all the correct duplicates but it does not keep the first duplicate.
    Looking at my table i need row 2, 3, and 4 dates to be visilble-as there is txt in Col B; Row 5 should be visible as it's the first of some duplicates that has txt in Col C; Row 6&7 should be hidden as they are duplicates with txt in Col C; Row 8 should remain as it has no duplicates with txt in Col C; Row 9 should remain visible, even though it is a duplicate of row 8 it has txt in Col B, so it MUST stay. Hope you can understand my jargon. I have tried posting this question before but got no resolve.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,427

    Re: Hide some duplicate dates with conditional format

    Try this CF formula instead:

    =AND(B2="",COUNTIF(A$2:A2,A2)>1,COUNTIFS(A$2:A2,A2,C$2:C2,"<>")>1)

    Seems to satisfy all your conditions.

    Hope this helps.

    Pete

  3. #3
    Forum Contributor Steve N.'s Avatar
    Join Date
    12-22-2011
    Location
    USA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    298

    Re: Hide some duplicate dates with conditional format

    Perhaps a pivot table will give you a useful result...
    Attached Files Attached Files

+ 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] conditional format duplicate values
    By keshavtale in forum Excel General
    Replies: 12
    Last Post: 08-12-2013, 08:02 AM
  2. [SOLVED] conditional format duplicate values
    By keshavtale in forum Excel General
    Replies: 2
    Last Post: 08-07-2013, 03:00 AM
  3. CONDITIONAL FORMAT: duplicate value in two colors
    By chatz86 in forum Excel General
    Replies: 3
    Last Post: 03-18-2013, 01:45 AM
  4. Replies: 9
    Last Post: 10-29-2012, 06:06 PM
  5. Conditional Format Dates in a Calender when Matches dates in a list
    By Lungfish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-14-2009, 06:23 AM

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