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