LinkBack URL
About LinkBacks
Basically what the title says. I have to make a function that takes in two arrays, and then it checks the max numerical value in the first array and spits out the corresponding text from array 2. How can I do this without using the max function?
Basically what the title says. I have to make a function that takes in two arrays, and then it checks the max numerical value in the first array and spits out the corresponding text from array 2. How can I do this without using the max function?
How many items are going to be in these arrays?
And what is the reason that "max" cannot be used?
This might be a start.
Change references where required
Please Login or Register to view this content.
Last edited by jolivanes; 03-06-2017 at 10:50 PM.
The LARGE() function could be used in place of the MAX() function, but, I don't see the reason for avoiding the use of the MAX() function. https://support.office.com/en-us/art...b-01672ec00a64
Originally Posted by shg
Like this
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
It's for a school assignment, but I don't really like the teacher so instead of going to her for help, I'm coming here. I've been stuck here for a while lol.
All you have to do now is hoping she does not read this and compares your solution to the suggestions here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks