You could use helper columns, C and D with Min(a1:b1) and Max(A1:B1) formulas
therein and copied down.....then Copy PasteSpecial Values on both of
those columns to get rid of the formulas and then delete columns A and
B.......or, if this is something you must do frequently, one could write a
macro to do it..........

Vaya con Dios,
Chuck, CABGx3



"Huseyin" wrote:

Hello,
I have two column of numbers, all the numbers in column A must be smaller
than the ones column B. For example, 170 in the 5th row, column B must be
switched with 200 in column A. Row 6 and the last row have the same problem.
Is there an easy way of doing this? Thanks.
A B
160 170
160 170
160 180
200 170
160 180
200 180