Hide cell values

[sdel_nevo]

Hi everyone

I'm really sorry if this has been asked before

I have a list of names starting in cell B13

Fully Factored
Stock
Stranding
Stranding
SWU
SWU

what I can't seam to get my head around is this

how can I hide the duplicate entry's and only have on value for each so the list would become

Fully Factored
Stock
Stranding
SWU

I just need to hide the text but can't think how I can do it

any help would be great

Steve

 

[mumps]

Hi Steve. One possibility is to change the font color to white. The value will still be there but you won't be able to see it because the font color will match the background color. This will leave your duplicate entries which will look like blank cells. If you don't need the duplicate entries, you can just delete them.

 

[sdel_nevo]

Hi Mumps

thanks for getting back, I'm not sure how I would go about this, I develop in access mostly and am just cutting my teeth with excel, how could I format this conditionally based on the duplicate values?

Steve

 

[mumps]

Do you want to hide the duplicates by changing the font color or do you want to permanently delete the duplicates?

 

[sdel_nevo]

Hi Mumps

I would like to Hide them by changing the font colour

Steve

 

[mumps]

Just a slightly different approach ... the following macro will hide the duplicate rows. It assumes your data is in column A starting at row 2. See if this will serve your purpose.

Sub HideDups()
    Application.ScreenUpdating = False
    Dim LastRow As Long
    Dim i As Long
    LastRow = Range("A" & Rows.Count).End(xlUp).Row
    For i = LastRow To 2 Step -1
        If WorksheetFunction.CountIf(Range("A" & LastRow & ":A" & i), _
        Range("A" & i).Value) > 1 Then Rows(i).Hidden = True
    Next i
    Application.ScreenUpdating = True
End Sub

 

[sdel_nevo]

Hi mumps

many thanks for this, I will try this first thing in the morning and let you know how I get on

Steve

 

[sdel_nevo]

Hi Mumps

That worked really well, many many thanks

Steve