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
|