View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GregR GregR is offline
external usenet poster
 
Posts: 246
Default Help with formula

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