Find column number

  • Thread starter Thread starter j.farr3ll
  • Start date Start date
J

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
 
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
 
Back
Top