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
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Conditional formatting if cell contains text - Excel Forum
- Which key is used to make multiple line in a single cell - Guide
- An example of a cell is a blank cell ✓ - Programming Forum
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!