Return position of value furthest to the right in a range - Lookup and Match Formula

[SuperCoog]

	A	B	C	D	E	F	G	H	I	J	K
1	4	100	200	300	300
2	3	50	100	100
3	5	25	50	15	225	541

<tbody>
</tbody>

Okay, I feel like I am almost there, I just can't get thisformula right.
I have a number of rows with data. Some rows use morecolumns than others. I want to be able to return the position of the value thatis furthest to the right in a row.
For example; row 1 has values listed in columns B through K.I want the cell A1 to return the value “8.”
Note: Some values may repeat, therefore I cannot use just astraight match function.
I’ve figured out how to return the value in thecell itself (ex. Position 8 has a value of 100) using a lookup function, butnot the position.

 

[Marcelo Branco]

If the values in columns B:K are numbers, this should work

A1 copied down
=MATCH(9.99E+307,B1:K1)

M.

 

[SuperCoog]

Worked like a charm. Thank you for your help.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.