Finding the first and last column with values

[Epmo]

I had a list in an excel sheet ordered by name and months. Each column (B..M)
represent a month (Jan thru Dec).

I'm trying to identify the first month of each person that has any value
">0" or <>"", and also the last month, but at this point I don't have any
clue.

Any support? thnx

 

[pinmaster]

Hi,

Try this:

First change your months into real dates if they are not already and format
as months. I suggest the first of each month. Then use these formulas:

=MIN(IF((B2:M2<>"")*(B2:M2<>0),B1:M1))
=MAX(IF((B2:M2<>"")*(B2:M2<>0),B1:M1))

both formula needs to be entered with Ctrl+Shift+Enter

HTH
Jean-Guy