Find column number

[j.farr3ll]

I have a table with columns headed 1 to 13 in cells A1 to m1. The rest
of the table displays the answer 1 once per row with the rest of the
columns in each row empty.

I need to display which column the 1 appears in for each row, i'm sure
there is a formula for this and any help would be much appreciated as
I have over 3000 rows to get a column number for.

Thanks

James

 

[Pete_UK]

Put this in cell N2 (for example):

=MATCH(1,A2:M2,0)

Then you can copy it down as far as required.

Hope this helps.

Pete