Using one cell to refer to many
Closed
Underwater
Posts
2
Registration date
Wednesday February 4, 2015
Status
Member
Last seen
February 5, 2015
-
Feb 4, 2015 at 06:34 PM
Underwater Posts 2 Registration date Wednesday February 4, 2015 Status Member Last seen February 5, 2015 - Feb 5, 2015 at 07:34 PM
Underwater Posts 2 Registration date Wednesday February 4, 2015 Status Member Last seen February 5, 2015 - Feb 5, 2015 at 07:34 PM
Related:
- Using one cell to refer to many
- Refer to the graphic what type of cabling is shown - Guide
- If cell contains date then return value ✓ - Office Software Forum
- Which example represents cell data with the date format applied to it? - Excel Forum
- An example of a cell is a blank cell ✓ - Programming Forum
- Excel send value to another cell - Guide
2 responses
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Feb 4, 2015 at 08:10 PM
Feb 4, 2015 at 08:10 PM
I would suggested leaving the date in per row as this makes thing far, far easier to analyze data.
Once all the data is in place then it can be reported on in anyway you want for reviewing numbers etc.
The best way to show what you need is by the use of Pivot Tables where data can grouped by fields you choose and totals applied to the groups.
They only need to be refreshed rather than recreated each time you need an update.
They are also not as scary as people think.
https://www.excel-easy.com/data-analysis/pivot-tables.html
Once all the data is in place then it can be reported on in anyway you want for reviewing numbers etc.
The best way to show what you need is by the use of Pivot Tables where data can grouped by fields you choose and totals applied to the groups.
They only need to be refreshed rather than recreated each time you need an update.
They are also not as scary as people think.
https://www.excel-easy.com/data-analysis/pivot-tables.html
Underwater
Posts
2
Registration date
Wednesday February 4, 2015
Status
Member
Last seen
February 5, 2015
Feb 5, 2015 at 07:34 PM
Feb 5, 2015 at 07:34 PM
I decided to just make separate sheets for each month, so I can keep it the way I want and still analyze it by month... Thanks for replying!
