Not sure how to solve this, maybe with macros.
Screenshot at Sep 05 17-26-46.png
I am using conditional formatting to show witch cells that have unique or duplicated date values.
I need a way to automatically hide an entire row, and only on instances where one of the column have a green date value. Like row 9 (G9 and H9).
How can I solve this?
Last edited by 6StringJazzer; 09-05-2019 at 12:46 PM.
Welcome to the Forum cptolsen!
As you suspect, this cannot be solved with conditional formatting and will need a macro.
Please attach your actual file. The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
I have also updated your title to reflect your actual question rather than anticipated solution.
Originally Posted by cptolsen
You can easily use a filter with the reverse condition …
How do you configure a filter that hides only unique (or only duplicated) data? Please be more specific with regard to the OP's example.
Instead of using conditional formatting, you can use a similar formula in a helper column which will return TRUE or FALSE (or duplicate/unique, or hide/keep etc.) Then you can apply a filter on that column to hide whichever rows contain the appropriate identifier.
Hope this helps.
Pete
Try this.
Sub HideDuplicate()
For x = Range("G" & Rows.Count).End(xlUp).Row To 1 Step -1
If x = 1 Then Exit For
If Application.WorksheetFunction.CountIf(Range("G1:G" & x - 1), Range("G" & x).Value) >= 1 Then
Rows(x & ":" & x).EntireRow.Hidden = True
End If
Next x
End Sub
Thanks to PaulSP8!
Thank you guys!!
Attached is the demo file.
One more problem that I did not think about, there is one value that is repeated many times in the time column (H) and that is the value "At bay". I also need to mark that one as not repeated, if not it will make some problems when removing rows.
Also, is there any place I can "translate" "english formulas" into "norwegian formulas", since I have to write them in my own language. If i use standard "english" formulas, i will get an error :/
There are some websites to convert Excel formulas between languages
but that's useless between English and your local version 'cause Excel stays internal in English !
Take a glance to this thread …
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks