A little help with my Excel problem

[quackers]

I'm sure this is really simple, but i'm crap at excel

say i've got two columns like below:

A1 B1
1 1
2 2
3 4
4 5
5 6
6 7

What i want is a forumla to sort and then display the numbers that is in one column but not the other column, so in this case number 3

Hope that makes some sense, i've got excel tunnel vision at the moment lol

Anyone got any ideas? This is doing my head in now!

 

[ArmyofHarmony]

Not sure what you mean... just highlight one row and do Data -> sort if you dont want the other row to move?

 

[|Ric|]

If you have something like:

=IF(COUNTIF($B$1:$B$6, A1)=0, A1, "")

going down column C, then the entries in column C are those that are in column A and not in B.

There is no sorting, but I don't see from the previous problem why you need to sort the list?

Also, should the answer be 3 and 7? Because 3 is no in column B and 7 is not in column A