Hey everyone, this is my first post!
I've figured out how to create a dynamic chart, where the last values of my data are forced to be blank using an IF formula. The range that I created for which this works has the following formula:
=OFFSET(Sheet1!$C$46,1,0,(COUNTA(Sheet1!$C:$C)-1)-COUNTIF(Sheet1!$C$47:$C$58,""))
I am now in need of using a range where I only want the last 3 values of my data. However, the bottom part of my data is blanked out by the IF formula, so I actually want the last 3 number values. So if I used the regular:
<TBODY>
</TBODY>
I've figured out how to create a dynamic chart, where the last values of my data are forced to be blank using an IF formula. The range that I created for which this works has the following formula:
=OFFSET(Sheet1!$C$46,1,0,(COUNTA(Sheet1!$C:$C)-1)-COUNTIF(Sheet1!$C$47:$C$58,""))
I am now in need of using a range where I only want the last 3 values of my data. However, the bottom part of my data is blanked out by the IF formula, so I actually want the last 3 number values. So if I used the regular:
=OFFSET(Sheet1!$B$1,COUNTA($B:$B)-3,0,3) I would only end up getting 3 zeros. I tried the following, but that didn't work: =OFFSET(Sheet!$B$46,1,0,(COUNTA(Sheet!$B:$B)-3,0,3)-(COUNTIF(Sheet!$B$47:$B$58,"")-3,0,3)) There must something I'm not understanding in the nomenclature following the COUNT functions. Please help! |
<TBODY>
</TBODY>