Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|