Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a table like this:
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Month $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $20,000 where row 1 is month name (different lines because of wrapping) row 2 is an amount (different lines because of wrapping). I need the cell after 20,000 which in this case is "S2" to return the month in which the value is 0. In this example the month would "Dec". TIA Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |