Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
number replacement
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
number replacement
This could be done with VBA but if it is a one-off situation here is a
process that works. 1 If needed insert 2 new columns after B ( they will be remove at the end) 2 In the new C1 enter =MIN(A1:B1); in the new D1 enter =MAX(A1:B1) 3 Copy these down the column (select C1 and D1 and double click D1's fill handle - the small solid square in lower right corner). I will assume the last cell is D100. 3 If necessary, select C1:D100 and use the Copy tool. 4 With the range C1:D100 still selected use the menu command Edit | Paste Special and specify Values in the dialog box 5 The range C1:D1 now has what you want so you can delete columns A and B best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Huseyin" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Number in Invoice | New Users to Excel | |||
From Template Save As Help | New Users to Excel | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |