Using one cell to refer to many
Closed
Underwater
Posts
2
Registration date
Wednesday 4 February 2015
Status
Member
Last seen
5 February 2015
-
4 Feb 2015 à 18:34
Underwater Posts 2 Registration date Wednesday 4 February 2015 Status Member Last seen 5 February 2015 - 5 Feb 2015 à 19:34
Underwater Posts 2 Registration date Wednesday 4 February 2015 Status Member Last seen 5 February 2015 - 5 Feb 2015 à 19:34
Related:
- Using one cell to refer to many
- Excel multiple lines in one cell - Guide
- How to delete one cell in word - Guide
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- Samsung button cell ✓ - WhatsApp Forum
- Conditional formatting if cell contains text - Excel Forum
2 responses
RayH
Posts
122
Registration date
Tuesday 31 August 2010
Status
Contributor
Last seen
20 June 2016
26
4 Feb 2015 à 20:10
4 Feb 2015 à 20:10
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 4 February 2015
Status
Member
Last seen
5 February 2015
5 Feb 2015 à 19:34
5 Feb 2015 à 19:34
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!