Find column number in row

[Cobber2008]

I’m trying to look from right to left in a row of Data but find a number that is less than another number and result the column number eg find find column number in a row range eg a5:A100 from right to left where the number is less than 7.5 then give me the column number of that cell. Preferablly not an array. Thanks.

 

[Alex Blakenburg]

Since you have 365 if you didn't want to use VBA you could just use this:

=IFERROR(COLUMN(XLOOKUP(TRUE,$A$5:$N$5<Q5,$A$5:$N$5,"not found",0,-1)),"not found")

If you wanted to use VBA do you want to start at row 5 and work your way down ?
Do you want to stop when it finds the first one ?
Where do you want the result especially if you want it to loop through all the rows ?
Will all the rows have the same number of columns ie can we use row 5 to work out how many columns to loop through ?

 

[Cobber2008]

Hey Alex thanks for your help. I ended up using this formula which if thinks works
Iferror(lookup(2/1/(al2:bm2>0)*(al2:bm2>=5)),(column(2:2)).0). Cheers

 

[Alex Blakenburg]

Thanks for letting me know. Glad you found something that works for you.