Thread
:
calculate last 4 data points in a column (with sometimes blank rows)
View Single Post
#
4
puck1263
Junior Member
Posts: 20
So, I looked at this again and must have copied something wrong.
Now I get the #NAME? error all the way down the column.
Here is what I have in the first cell (row 19)
SUM(INDIRECT("AY"&LARGE(IF(ISBLANK(AY19:AY1000),0, RO AY(19:1000)),4)):AY1000)
Reply With Quote
puck1263
View Public Profile
Send a private message to puck1263
Find all posts by puck1263