Formula to state the previous 12 months in text, based on changing contend in a cell

[Anandpersad]

Hi All,
I need help with the following issue:
I have a database (Sheet name is Data) in which data is updated monthly.

Based on this data base I have put the following formula in an additional sheet (sheet 2). In cell O8, I have the following formula: =LOOKUP(2;1/(Data!K:K<>"");Data!K:K)
This will go in sheet "data", go to the last row which is not empty, and give the month name as mentioned there in column K).
What I am looking now, is a formula which will give the names of the previous 12 months in "mmm"
So cell N8, wil give December, cell M8 will give November,.......... and cell C8 will give January.

If the name of the month in cell O8 changes to e.g. Februari, the month names in the cell (c8...N8) has to change accordingly.

Thanks for your help

Anand

 

[Anandpersad]

The formula I posted is actually Fluff's formula with a small tweak. I haven't been following this thread... I simply commented on what I saw that he posted. You might want to attach a picture that is readable though as I cannot make out anything on what you posted. Better would be to upload an actual copy of the workbook to, say, DropBox so we can see your actual data and how the formula interacts with it.

Formula to state the previous 12 months in text, based on changing contend in a cell

 

[MARK858]

You probably didn't mark the file for sharing then pasting the link it provides as I get...

 

[Anandpersad]

Link was wrong

 

[Anandpersad]

You probably didn't mark the file for sharing then pasting the link it provides as I get...

View attachment 8604

kri (483) 202001 for Karin.xlsx

 

[Anandpersad]

Formula to state the previous 12 months in text, based on changing contend in a cell

kri (483) 202001 for Karin.xlsx