Complete numpty when it comes to spreadsheets as never really had to use them, (read, got my PA to do them when I had one)..
So, trying to create a daily running total displayed, it's for medications as a guide for me to watch the old UN's, especially as with dementia creeping in, I need to be able to work out if they've remembered to take tabs..
Re: Spreadsheet help..
Posted: Fri Jan 12, 2024 10:53 am
by Insane_Homer
Probably a pivot table to make sense of the raw data, you can then add Slicer to filter the data.
Pivot Table
Slicers
Re: Spreadsheet help..
Posted: Fri Jan 12, 2024 11:08 am
by TB63
My head hurt watching those..
I want for example. B5 minus 1 to show daily remaining tabs..
Re: Spreadsheet help..
Posted: Fri Jan 12, 2024 11:42 am
by Sandstorm
TB63 wrote: Fri Jan 12, 2024 11:08 am
My head hurt watching those..
I want for example. B5 minus 1 to show daily remaining tabs..
Reboot
Re: Spreadsheet help..
Posted: Fri Jan 12, 2024 4:07 pm
by Ymx
If you want to sum total of column next to it.
Say if C has daily pills
D is blank with total pills which you want to be the sum
In cell D2, put =C2
In cell D3, put =D2+C3
Then copy the D3, and paste it in D4, and so on.
D should then be the total of C
Re: Spreadsheet help..
Posted: Fri Jan 12, 2024 4:11 pm
by Insane_Homer
TB63 wrote: Fri Jan 12, 2024 11:08 am
My head hurt watching those..
I want for example. B5 minus 1 to show daily remaining tabs..
Apologies I didn't realise you were that excel/PC illiterate.
not that illiterate...