Forum Discussion
how to integrate "isblank" with other formulas
Hi all, I'm not sure where to insert a "isblank command in my formula, what are the rules with doing this? I want to do a duplicate count and transfer the data to a pie chart without the blank cells...
you need to create dynamic ranges. If imitate on such model
we may create two named formulae for dynamic ranges
Here they are
=Sheet1!$D$3:INDEX(Sheet1!$D$3:$D$99, COUNTA(Sheet1!$D$3:$D$99) )
=Sheet1!$E$3:INDEX(Sheet1!$E$3:$E$99, COUNTA(Sheet1!$D$3:$D$99) )Right click on the chart, Select Data and update Series and X Axis like