Forum Discussion
Solved
Help with forumla
I have been struggling to work out the correct formula in the attached spreadsheet. What I am trying to do is to work out how many Job’s each solar provider has done per state. I have tried V & X loo...
By removing of all formulas within source data range
Hi Sergi, I still seem to be having trouble removing all of the formula's.
In the attached extract I have not removed any formula's, when you click on a blank cell you can still see the formula even though there is no result.
If I highlight column E it will show a count of 9 as every cell has a formula.
If I copy and use paste special to paste only the values, the formula's are removed and the blank cells in column E show no formula however when I highlight the column again it is still counting 9. I assume there is something hidden there that I am having trouble removing.
What am I doing wrong?
Appreciate your help.
