Hello kind and smart people.
I have been going through 20+ forum posts but I simply can't make it work...
I want to name the range M5:W30 so that I can later make it into a dynamic chart. Cells M5:W30 contains a formula that is automatically updated based on an input. The problem is however that sometimes only cells M5:W25 will contain numbers, and M26:W30 will then be blank (but with a formula in the cell it only looks blank). I cant get excel to understand this, and it therefore always include all cells because it cant understand that some cells are blank because they still have a formula... What formula should i create my named range on in the name manager so that it does not include cells that the formula has made blank.
Note that these blanks will always be in the end, and that if there is 1 blank on the row then all others become blank automatically.
Sheet name is: Analysis
I have tried: =Analysis!$M$5:$W$5:INDEX(Analysis!$M$5:$M$30,MATCH(1,1/(Analysis!$M$5:$M$30=""),0)-1)
Bookmarks