Greetings Peers,

I am new to this forum. I have read thru the forum anything near to my topic, but i still dont understand anything. If any kind peers out there willingly to teach me step by step. Your help will be appreciated. Thanks in advance. here goes, This is wat i need in my excel :

Firstly,I want to compare at least 4 columns of data.

EG:
c1 c1 c1 c1
c2 c2 c2 c3
c3 c3 c3 c4
c4 c4 c5 c5

When there is a difference in the column i wish to insert a empty cell in that column only and colour the empty cell.Like there is a difference in the column 4 , C2 is missing and column 3 , C4 is missing.

Isn't there anyone who can help me?

Are the values always incremental (1,2,3,4, etc), or do they jump
around?

You do not have to check all 4 columns, just look at the sequence in
any given column for a skipped value.


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=549803