Need a insert a empty cell if compare different function

S

saici

Greetings Peers,

I am new to this forum. I have read thru the forum anything near to m
topic, but i still dont understand anything. If any kind peers ou
there willingly to teach me step by step. Your help will b
appreciated. Thanks in advance. here goes, This is wat i need in m
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 cel
in that column only and colour the empty cell.Like there is
difference in the column 4 , C2 is missing and column 3 , C4 i
missing
 
S

saici

Isn't there anyone who can help me?
Greetings Peers,

I am new to this forum. I have read thru the forum anything near to m
topic, but i still dont understand anything. If any kind peers ou
there willingly to teach me step by step. Your help will b
appreciated. Thanks in advance. here goes, This is wat i need in m
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 cel
in that column only and colour the empty cell.Like there is
difference in the column 4 , C2 is missing and column 3 , C4 i
missing
Click to expand...
 
B

bgeier

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.
 
Top