Hello:

I have a chart from A1:H10. I want a code to check each row seperatly, if a
cell is equal with the same value of another cell on that row, it should not
show the result.

The problem is that the chart is all full of formulas, as it pulls the data
from somewhere else. So if I make a code that deletes the value, then I'll
lose the formula which I don't want. However, I was thinking of using a
forumla to check if the previous cell is the same, but I think it will make
the formula extremely long, which now is already very long (six rows long
formula).

Is it possible to write a code so it only "hides" the value, if a cell on
that particular row has already the same value? Of course one cell should
stay with that value visable.

Thanks, hope someone understands my question.

Art.