Find last specified value in a row...and some

[bobcox]

Apologies if this has been covered before and I'm having trouble finding help elsewhere.

I have rows of integers and want to find the minimum value from the final appearance of specified value eg
Row is 3 5 7(A) 6 3 7(B) 5 4 3 6
So I want to find the minimum value from 7(B) i.e. the last appearance of integer 7 - so I'm looking for the 3 in the 9th column.
Any help much appreciated

[Special-K]

Are the values on the row 7(A) and 7(B) or simply 7 ?
Consequently the value you are searching for is it 7(A) or simply 7 ?

What happens if there is more than one minimum value on the row, ie instead of 5 4 3 6 you have 5 3 3 6 ? Is this likely to happen and what sort of output would you expect in this instance?

[Special-K]

Here you go

=MIN(IF(COLUMN(A1:J1)>MAX(IF(A1:J1=8,COLUMN(A1:J1))),A1:J1))
Array formula, use Ctrl-Shift-Enter

[bobcox]

Thanks Special-K
Sorry I hadn't replied to your first post but you sorted it out (yes all figures are simple integers and I need the min irrespective of how many duplicates there are (its a golf related spreadsheet!).
I haven't had a moment to add it to my worksheet yet but I'm sure it will do the job...and I will try to understand the logic!
Many thanks.