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

[SuperCoog]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[TD]K
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]4
[/TD]
[TD]100
[/TD]
[TD]200
[/TD]
[TD]300
[/TD]
[TD]300
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]50
[/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]5
[/TD]
[TD]25
[/TD]
[TD]50
[/TD]
[TD]15
[/TD]
[TD]225
[/TD]
[TD]541
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.