#1
|
|||
|
|||
Put the smallest non-zero value from columns A & B into column C
I need a comand that would take value from A and B colum and pick the smaller one to put in colum C. But if obe colum has no value it has to choose the one with value. Like If colum A row 2 value is 0 and in colum B row 2 value is 20. It hase to choose 20.I realy strugle with excel and if you could help me that would be nice. thank you in advance
A B C 15 36 15 It piks the colum A because 15 is less than 36 0 20 20 It piks the colum B because any number is better than 0 60 75 60 It piks the colum A because 60 is less than 75 5 4 4 It piks the colum B because 4 is less than 5 49 0 49 it piks the colum B beacause anynumber is better than 0 And so on Thank you ! |
#2
|
||||
|
||||
row 2:
Code:
=MIN(IF(A2:B2,A2:B2,"")) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Worlds Smallest PPT File | dwseppala | PowerPoint | 1 | 11-07-2013 06:43 AM |
Split one column to several columns | moishy | Excel Programming | 1 | 02-01-2013 12:50 AM |
Columns. How to move the left column so it's to the right of the 'right' column ? | Vit | Word | 9 | 11-21-2012 12:57 PM |
Fill column with other columns info | Novice | Excel Programming | 10 | 07-28-2011 09:45 AM |
How to expand one column into two columns? | Jamal NUMAN | Excel | 1 | 01-12-2011 07:59 PM |