Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-02-2022, 07:15 AM
Petras Petras is offline Put the smallest non-zero value from columns A & B into column C Windows 10 Put the smallest non-zero value from columns A & B into column C Office 2019
Novice
Put the smallest non-zero value from columns A & B into column C
 
Join Date: May 2022
Posts: 1
Petras is on a distinguished road
Default 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 !
Reply With Quote
  #2  
Old 05-02-2022, 07:45 AM
p45cal's Avatar
p45cal p45cal is offline Put the smallest non-zero value from columns A & B into column C Windows 10 Put the smallest non-zero value from columns A & B into column C Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

row 2:
Code:
=MIN(IF(A2:B2,A2:B2,""))
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Put the smallest non-zero value from columns A & B into column C 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
Put the smallest non-zero value from columns A & B into column C How to expand one column into two columns? Jamal NUMAN Excel 1 01-12-2011 07:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft