Finding the first and last column with values
 

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

Finding the first and last column with values
 

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
"Epmo" wrote:

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