D
Denise_NOLA
Does Excel recognize months in their chronological order? For example I have
the following data:
Jan Feb Mar
Reg 1 5 9 11
Reg 2 8 9 7
Reg 3 10 16 12
I am trying to write a formula that will give me the data for all three
regions for all months less than or equal to February (so Jan & Feb). But I
want the formula to look at all the months so that I can change my search
criteria for each month that passes.
Any help will be greatly appreciated!
the following data:
Jan Feb Mar
Reg 1 5 9 11
Reg 2 8 9 7
Reg 3 10 16 12
I am trying to write a formula that will give me the data for all three
regions for all months less than or equal to February (so Jan & Feb). But I
want the formula to look at all the months so that I can change my search
criteria for each month that passes.
Any help will be greatly appreciated!