Forum Discussion
EXCEL Dashboard
EXCEL Dashboard
Hi Excel community
- I have this project I wish to implement at work, but I am kind of stock.
- I have a database of clients who pick up medications from the facility periodically.
- I wish to build a dashboard where when I input the client's code (Personal ID), excel gives me in return all the days the client came for pickup and the services he received each of these days.
- I have tried, but only succeeded to have a single day appear on my dashboard.
- I’ll be glad to hear from all
6 Replies
Here is a solution that will work in
all versions ofExcel 2007 and later.If all users will have Microsoft 365 (or, soon, Office 2021), the formulas can be a lot simpler.
- AbaasanjiCopper ContributorThanks
Checking it now - SergeiBaklanDiamond Contributor
No way, I still see users on Excel 2000 and even on Excel 97. That was nice time and we were younger.
Yikes!
- SergeiBaklanDiamond Contributor
On which Excel version / platform you are ?
- AbaasanjiCopper ContributorMS 2016