VBA to show cell blank if cell value is same as cell above

[Merlot85]

Good Day,

I am very new to coding and would like to ask for assistance in writing a code to:

Show the cell as blank if the cell above contains the same value. I would like to do this for a range of cells. Also the cell values may differ eg.

Bahamas
Bahamas
Bahamas
England
England
Unites States
United States
United States

Would anyone also be able to guide me as to where I can begin if I would like to learn to write codes on my own?

Thanks in advance

 

[Joe4]

Welcome to the Board!

I think the easiest way to do this is to use Conditional Formatting. That won't actually delete those values, but rather "hide" them from view.
Let's say that your values are in A1-A8.
Then, highlight cells A2:A8, and enter the following Conditional Formatting Formula:
=A2=A1
Then choose the white font option.

So, if the value in once cell is the same as the value above it, the font color of that cell will be changed to the same color as the background, making that value not visible.

 

[cerfani]

sounds like you would just setup conditional formatting. Under the home tab on the ribbon you can find it. The idea is you would apply it to whatever range of cells you like and you create a formula that results in true or false and you create the formatting for if it is true. So your formula would compare the current cell to the one above it. It is a little tricky how you write the formula as it works for the first cell and as if you dragged the formula for others (huh? lol)

Look at my rule for E6:E12 (ignore the other stuff) I assure you the value 5 and 4 are now hidden in E8 and E12. For formatting I used a custom number format where I just put two quotes ""

 

[Merlot85]

Thank you both so very much! I would not have thought of this. It works great!