View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Huseyin Huseyin is offline
external usenet poster
 
Posts: 3
Default number replacement

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