Nicki has attended:
Excel Dashboards for Business Intelligence course
Excel dashboard
Hi.
I have created a valid list based on month-year.
I would like that when any year is selected in the valid list, a total of 12 other cells display the 12 months from the selected month-year in the valid field.
I am not sure which is the best formula to use!
many thanks
RE: Excel dashboard
Hi Nicki,
Thank you for the forum question.
Which formula is the best one to use depends on how your source data are organised.
I have created an example file (See attached file). I have the source data in a list and I have use the Sumproduct function. Please see how I have formatted the dates in column E and J.
I hope this can guide you in the right direction.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
Dashboard.xlsxRE: Excel dashboard
Thank you Jens but I cant see the attachment :-(
RE: Excel dashboard
Hi Nicki,
Please try to refresh your browser (Press F5).
If it is still not visible please send me an email:
jens@stl-training.co.uk
Then I will send the file to your email address. You will not need to type anything in the email, I just need your email address.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Excel dashboard
thanks for the reply Jens. I havent explained myself too well, so I have created a file to try to explain...Is there a way I can upload the file as I cant see any attachment options..
RE: Excel dashboard
Hi Nicki,
Please send the file to:
jens@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
