Oct 02 2021 07:52 AM
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
Oct 02 2021 09:13 AM - edited Oct 02 2021 09:55 AM
Here is a solution that will work in all versions of Excel 2007 and later.
If all users will have Microsoft 365 (or, soon, Office 2021), the formulas can be a lot simpler.
Oct 02 2021 09:35 AM
No way, I still see users on Excel 2000 and even on Excel 97. That was nice time and we were younger.