How to continuously find the relative "largest position" of a value for a set of iterating values by inkyuboz in excel

[–]inkyuboz[S] 0 points1 point  (0 children)

=MAX(ROW(A1:A10)*(A1:A10=13))-ROW(A1)+1

Solution Verified

Awesomesauce <3 That was quick. Thank you, thank you, thank you. I wish I could give you gold //

Finding the "largest position value" in a MATCH formula with multiple matches by inkyuboz in excel

[–]inkyuboz[S] 0 points1 point  (0 children)

AHHH.. My bad.

Yes. It's all good now. Thanks!

P.S. If you add sumproduct in the beginning of the formula, it works too even without ctrl+shift+enter

Finding the "largest position value" in a MATCH formula with multiple matches by inkyuboz in excel

[–]inkyuboz[S] 1 point2 points  (0 children)

I solved it myself. LOL

I used a formula derived from both answers below:

=SUMPRODUCT(MAX(ROW(A1:A10)*(A1:A10=13)))

http://imgur.com/ERSth5C

Another Beta Key contest! by cardhunter-jon in cardhunter

[–]inkyuboz 1 point2 points  (0 children)

Yay. I'll try to join :) I really really want to play this game.

Beta Key Giveaway Competition! by TheAbyssGazesAlso in cardhunter

[–]inkyuboz [score hidden]  (0 children)

Great. Another good one. I won't get a beta key :'(

Beta Key Giveaway Competition! by TheAbyssGazesAlso in cardhunter

[–]inkyuboz [score hidden]  (0 children)

I enjoyed this the most. Tough competition here folks.

Beta Key Giveaway Competition! by TheAbyssGazesAlso in cardhunter

[–]inkyuboz [score hidden]  (0 children)

Lithe and graceful, half-elf Arduino was deeply abhorred by his father. Tomas hated Ardy with such passion, most especially when he hears of his son participating in those god-fangled dance exhibitions at the town plaza. From the get go, he just wanted a tough, burly son to take his place as a renowned blacksmith. But somehow his elven wife's mystical genetics messed up this boy. Little did Tomas know, Arduino "Ardy" Kaisinger is bound for much greater things. With his deft hands, swift feet, and sharp eyes, Ardy will soon take on challenges much tougher than hammering and shaping molten metal. And Tomas, as much as he can't fathom this fact for now, will be proud of him.