finding the last 3 months in a table

[hg090589]

Hello,

I have a table with months I and various figures for each month.

I am wanting to display in columns O the last 3 months that have data in column D (completed).
For Example below August, September and October should have a 1,2,3 in column O

This is what I have but it won't work.
=IF(AND(D4>0,ISBLANK(D5)),1,IF(O5=1,2,IF(O5=2,3,””)))

Month	Tasks Scheduled by Pirana	Completed Pirana Tasks	Incomplete Pirana Tasks	Completion Rate	Tasks Scheduled by Pirana	Completed Pirana Tasks	Incomplete Pirana Tasks	Completion rate	Tasks Scheduled by Pirana	Completed Pirana Tasks	Incomplete Pirana Tasks	Completion Rate	last 3 momths
July 2018	1513	266	1246	18%	246	44	202	18%	35	17	18	49%	#NAME?
August 2018	1079	139	940	13%	1155	119	435	10%	50	13	37	26%	#NAME?
September 2018	1312	306	1005	23%	294	228	0	78%	28	6	22	21%	#NAME?
October 2018	1898	309	1588	16%	226	37	185	16%	34	8	26	24%	#NAME?
November 2018	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?
December 2018	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?
January 2019	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?
February 2019	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?
March 2019	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?
April 2019	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?
May 2019	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?
June 2019	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?
July 2019	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?
August 2019	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?
September 2019	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?
October 2019	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?
November 2019	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?
December 2019	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	#DIV/0!	#NAME?

<colgroup><col width="119" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4352;"> <col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"> <col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;"> <col width="64" style="width: 48pt;" span="9"> <col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;"> <col width="64" style="width: 48pt;"> <tbody> </tbody>

 

[Fluff]

Re: finding the last 3 momths in a table

The quotes are the wrong type they should be " not ”
also you're testing if D5 is blank, but from your post it never will be.

 

[hg090589]

Re: finding the last 3 momths in a table

The quotes are the wrong type they should be " not ”
also you're testing if D5 is blank, but from your post it never will be.

Hi thanks for replying.

that quotes are right in my spreadsheet it’s just wrong on here for some reason.

Also i realised it is looking for blank, do you know how i would amend that formula to say greater anything but 0 instead of isblank


thanks for your help

 

[Joe4]

Re: finding the last 3 momths in a table

do you know how i would amend that formula to say greater anything but 0 instead of isblank

I am afraid that part in red is not very clear.

Do you want greater than zero like this:

D5>0

or equal to zero like this?

D5=0