Hi there
i have the following array of number in cell D3 to D7 : 1 2 0 -1 -2
Then in cell F3 to F8, i need a function to search the above Array for the largest number, then return the position of that number. If the position is the same, then return true, if not, return false.
Sorry for my bad english, if it is not clear enough, please check the attach file.
Thanks much everyone
hi DanielMinh, try:
=MAX($D$3:$D$7)=D3
to find the position:
=MATCH(MAX($D$3:$D$7),$D$3:$D$7,0)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
If the position is the same, then return true, if not, return false
Array for the largest number, then return the position of that number
Please Login or Register to view this content.
Edit:Please Login or Register to view this content.
Ops, my answer is late. Is same as benishiryo did.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
I'm nor sure you want to get sth like that, but I hope this is felpful
Thanks all for your answer. That is very fast ^^
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks