Forum Discussion
VERY DIFFICULT TO EXPLAIN
DaCrab_101 wrote: Yeah I drive my CPA nuts too...
I'm sure you do.
To be blunt, your design gets in the way of Excel's abilities to help you accomplish what you want to do. So many blank rows is (more accurately, it may be) a way to help humans look at data and see things more clearly.
Arranging your data that way, however, gets in the way of Excel's abilities to use a clean array of data as a database and, based on that, perform the kind of summaries, data extractions--analyses of various types--that Excel excels at.
So for the mental health of any here who might be able to help--and, who knows, maybe the mental health of your CPA as well--are you open to re-designing your whole approach?
DaCrab_101 wrote: Yeah I drive my CPA nuts too...
I'm sure you do.
To be blunt, your design gets in the way of Excel's abilities to help you accomplish what you want to do. So many blank rows is (more accurately, it may be) a way to help humans look at data and see things more clearly.
Arranging your data that way, however, gets in the way of Excel's abilities to use a clean array of data as a database and, based on that, perform the kind of summaries, data extractions--analyses of various types--that Excel excels at.
So for the mental health of any here who might be able to help--and, who knows, maybe the mental health of your CPA as well--are you open to re-designing your whole approach?
