How I find the first column?

NWenzel

I have a range of columns with 14 milestones.

If the milestone reached, then it will be delete and the cell is blank.

Now I would know, in which column are the first date. As result I would need the column-name, with the first date or the number of column, counted from the first column of the range.

Any ideas, which formula I can use for it?!

Paul Newcome

Try something like this to output the number

=MATCH(INDEX(COLLECT([1st Column]@row:[Last Column]@row, [1st Column]@row:[Last Column]@row, @cell <> ""), 1, 1), [1st Column]@row:[Last Column]@row, 0)

Paul Newcome

Try something like this to output the number

=MATCH(INDEX(COLLECT([1st Column]@row:[Last Column]@row, [1st Column]@row:[Last Column]@row, @cell <> ""), 1, 1), [1st Column]@row:[Last Column]@row, 0)

NWenzel

Hi Paul - many thanks! It works, perfect!!!

Paul Newcome

Happy to help. 👍️