Using index to return data from list for last 12 months or months available

[welchs101]

Hi, I have several columns of data. The first column in the list is a column of dates. Basically, what i want to do is return the last 12 months of dates and associated data. Now, keep in mind that the column of dates may not contain 12 months of data so you just return all months shown and associated data.

I have enclosed a file to help show what i want because trying to describe it via words is kinda hard.

[welchs101]

for got to attach the file........

[Fotis1991]

One way could be this.

In R2 and copy down(you can hide this column).

=COUNTIF($O$2:O2,O2)

Then in U2 and copy down, use this ARRAY formula.

=IFERROR(INDEX($O$2:$O$13,SMALL(IF($R$2:$R$13=1,ROW($O$2:$O$13)-1),ROW(O1))),"")

[welchs101]

thanks.......but is there a way to do it with a single formula that is NOT an array formula?

[welchs101]

ok...this is what i finally came up with........see enclosed file.........seems to work. Soln is in cols y through AJ.


not sure its the best one but it does seem to work.

[Fotis1991]

not sure its the best one but it does seem to work.

No one is never sure that his own is the best one!