hi,
I am trying to setup a formula where the formula picks up the information
for the latest month available... for ex., below i have information for Jan
and Feb available - right now my formula picks up February's number and
compares it to another cell... i want to be able to setup the formula in a
way where when march becomes available the formula will pick up march and
compare it to my fixed number. is there a way to do this?

Jan Feb Mar Apr May Jun Jul
1000 1500