Location of the last occurrence of month in range

Hi -

How do you find the last of occurrence of the month in Column A. Please see below print screen.

Based on the print screen 3 is the location of the first occurence of January how about the last occurrence? what is the formula that I'm
going to use?

I've already tried =MATCH("January",A1:A22,1) but its giving me 22 which is suppose to be 8.

Need help please

Thank you
untitled.JPG

Try:

=MATCH(2,INDEX(1/(A1:A22="January"),0))

Hi

Maybe this, will work for you.

=MATCH(2;INDEX(1/(A1:A22="January");0))

Change semi-colos, to gomma, if you have to do it.


And, pls: Don't upload a picture. Upload a sample workbook.

You are welcome!

Teacher will do it! Iam just a (good i hope) student(and my English are not so good,for explanations, too)!!

So, I gotta go now.. so not to leave you hanging....


this part: (A1:A22="January")

creates an array of TRUE/FALSE results....

The 1/(A1:A22="January")

divides 1 by each of the TRUEs and FALSEs...

1/TRUE is like 1/1 and results in 1/(A1:A22="January") function without having to hit CTRL+SHIFT+ENTER since it technically is an ARRAY formula...

so we get a result like MATCH(2,{1;1;1;1;#DIV/0;#DIV/0;#DIV/0;}) or similar...

the MATCH function without the last Match_type argument allows you to find the last value that is smaller than or equal to the lookup value... so we are looking for a 2 amongst 1's and #DIV/0 errors... and the function ignores errors, so it goes to the last 1 in the array, and returns the corresponding position.

You can use the formula evaluator found in the Formulas tab to step through it yourself to see it at work....
1/FALSE is like 1/0 and results in #DIV/0! error

the INDEX wrapped around that allows us to process that

Can you give an example of the raw data and what you want to extract?

Okay, let's keep it separate then... I responded over there.