I'm trying to return the row of the smallest number in a table. =row(X) only lets you select a range, not nest a function.
Something would work like =row(small(X:X),1) should be doing.
You guys have any idea?
I'm trying to return the row of the smallest number in a table. =row(X) only lets you select a range, not nest a function.
Something would work like =row(small(X:X),1) should be doing.
You guys have any idea?
=match(small(a1:a20,1),a1:a20,0)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi,
Try something like this.
=ROW(INDIRECT(ADDRESS(MATCH(SMALL(A1:A15,1),A1:A15,0),1)))
HTH
Steve
Over complicated this! Just back from PTO....
=MATCH(SMALL(A1:A15,1),A1:A15,0)
Steve
Last edited by SteveG; 06-28-2012 at 12:59 PM.
thanks guys I'll try both and see what will work easiest with the rest of the program.
http://www.excelforum.com/excel-gene...-new-post.html is what it's pertaining to.
Martindwilson you might have just saved me a lot of trouble googling.
DKahmer,
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for 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)
Bookmarks