Forum Discussion
Solved
Subtotal Report Not Working
Hi Folks, I am trying to use the Subtotal Report in Excel, assuming I have the right thing. The data I have is very simple, in two columns. Column A is a list of names, and Column B is house ...
CMSCMSCMS Fixed it. There was something odd about the point data. It had the green triangles in the top left corner, although despite a bit of googling I couldn't find any clear information about what they signify other than an error (but this is just numbers?!). I copied the numbers to notepad, then copied them to a new spreadsheet, and now it works.
CMSCMSCMS Apparently green triangles can signify numbers formatted as text, although I did change the formatting to numbers 🤷:male_sign:
Yes, that's only an alert says the values which looks like numbers are saved as text. You may select them and from the icon drop-down menu convert to numbers