LinkBack URL
About LinkBacks
this should be very simple. please see attached XLS.
why can't A8 find the value in the table? am i missing something?
this should be very simple. please see attached XLS.
why can't A8 find the value in the table? am i missing something?
Try this........
Or with Index-Match try this......
Please Login or Register to view this content.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
neither of those formulas return the correct answer (which should be 1). the idea is simply to find the relative position of the minimum value in an array.
MATCH is working on single-column or single-row ranges but as soon as i try 2 columns or 2 rows it returns #NA.
i have tried using absolute cell references ($) which didn't help either. i don't get it, i used to do this and it always worked.
Match works on a single column or row, it does not work on an array like that
You could perhaps try something like this?
=IFERROR(MATCH(A7,A1:A5,0),MATCH(A7,B1:B5,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
OK. Try this...........This is an array formula so need to confirmed by Ctrl+Shift+Enter
Please Login or Register to view this content.
thanks, i see what you are getting at and i think i could tweak that to make it work.
what is working for me is to divide and conquer: first, find the min value for each row of the 8 columns (individually) and put this into a cell. then find the min value of the 3 results.
thanks again and happy new year
Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.
In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.
Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.
Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks