I have 3 random numbers being generated on Sheet2, I already know how to show them on Sheet1; but what I want to do is only show the highest of the 3 random numbers on Sheet1?
Does anybody know what VBS or formula I can use to do this.
Thanks in advance, y'all rock.
Last edited by BadWolfBay75; 04-20-2014 at 10:56 PM.
Use the MAX formula?
多么想要告诉你 我好喜欢你
What's that and is it used how I'm asking? Selecting the highest number out of 3 randomly generated numbers?
Let's say your 3 random numbers are in A1:A3 of Sheet2, in whichever cell you want the highest value to be displayed in Sheet1, put this formula:
Please Login or Register to view this content.
Awesome, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks