How to find last specific number in row

[Mr Jukebox]

In row 1 I have the numbers 1 through 7 running on a loop so A is 1 B is 2 .... F is 6 G is 7 and then H starts back over at 1 what i want to be able to do is find the last lets say number 2 in the row how would i do this?

Thanks in advance

 

[poolhall]

this formula will give you the column number of the cell in row 1 where the last occurrence of number 2 is:

=MAX(IF(A1:AB1=2,COLUMN(A1:AB1)))

A1:AB1 is your range. Enter the formula using Ctrl+Shift+Enter as it is an array formula.

 

[barry houdini]

You could use this formula

=MATCH(99,INDEX(1/(1:1=2),0))