aligning two columns

[mikkellund]

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

 

[CLR]

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