Forum Discussion
Kindly help
I exported a file in Excel that shows two columns with min income and Max income. Now when I exported the file, Excel made three columns in total where I see majorly figures are in 2 columns but a fe...
OliverScheurich any way to do this without macros in Excel?
=IF($A1<>"",A1,B1)Maybe with this formula. The formula is entered in cell D1 in the attached example and copied across range D1:E46. Now you can copy this range and paste only values. Then you can delete columns A, B and C.