aligning two columns
 

Hello,

Pardon me if this is the wrong place to ask, but I'll try anyway.

I want to allign two columns of number that I am working on. One column
has 400 values, the other has 600. I want to find the ones that only
appear in the column with 600 values.

This leads me to find a function where pressing the 'enter' button does
not change the value of a cell, but rather it pushes/moves the column
further down one notch.

Any help would be greatly appreciated to finding this function. Thank
you.

Mikkel Jensen


--
mikkellund
------------------------------------------------------------------------
mikkellund's Profile: http://www.excelforum.com/member.php...o&userid=24978
View this thread: http://www.excelforum.com/showthread...hreadid=385100

If all you want is a way to make the cursor move down one cell after typing
ENTER, then do Tools Options EditTab check the box "Move selection
after Enter", and select "Down" from the dropdown OK..........

But if you want to compare the two columns automatically then I suggest you
look at the VLOOKUP function........

Vaya con Dios,
Chuck CABGx3



"mikkellund" wrote
in message ...

Hello,

Pardon me if this is the wrong place to ask, but I'll try anyway.

I want to allign two columns of number that I am working on. One column
has 400 values, the other has 600. I want to find the ones that only
appear in the column with 600 values.

This leads me to find a function where pressing the 'enter' button does
not change the value of a cell, but rather it pushes/moves the column
further down one notch.

Any help would be greatly appreciated to finding this function. Thank
you.

Mikkel Jensen


--
mikkellund
------------------------------------------------------------------------
mikkellund's Profile:
http://www.excelforum.com/member.php...o&userid=24978
View this thread: http://www.excelforum.com/showthread...hreadid=385100