find the first value greater than one in a row

i want to find the first value greater than one in a row and return the relevant column number of that cell.

i found a function with INDEX and MATCH to do this task.but it doesn't work with the data table which i want.
i have attached the relevant excel sheet here.
in here that function works well with table 1.but it doesn't work with table 2.i couldn't understand what is the problem with it.
please help me to find correct function and if you know the reason to failure my function let me know the reason for it

thanks in advance

Originally Posted by benishiryo

hi rsami. did you know that your data contains spaces? spaces are considered to be greater than 0. try this instead:
=INDEX($B$12:$AC$12,,MATCH(TRUE,ISNUMBER(B13:AC13),0))

Hi Benishiryo,
thanks very much and it works perfectly.

if you don't mind can you explain me what is the reason for it does not consider spaces in table 1 ?
it gives the answer although there are spaces,are they consider as 0?

Originally Posted by benishiryo

you're very welcome. your Table 1 doesnt contain spaces. you can use these formula for eg:
=LEN(B3)
=LEN(B13)

1st one will give you zero while the 2nd gives you 1. you can also copy B13 & press CTRL + F. then paste. you'll see a space. since spaces, texts & other symbols are considered to be greater than a number, your MATCH statement for >0 will give you TRUE for the very 1st column (the spaces found in column B)

hope that helps

i understood the situation.
thanks very much again

rep+