EXCEL Dashboard

%3CLINGO-SUB%20id%3D%22lingo-sub-2805752%22%20slang%3D%22en-US%22%3EEXCEL%20Dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2805752%22%20slang%3D%22en-US%22%3E%3CH3%20id%3D%22toc-hId--2125354166%22%20id%3D%22toc-hId--2125354075%22%20id%3D%22toc-hId--2125354075%22%20id%3D%22toc-hId--2125354075%22%20id%3D%22toc-hId--2125354075%22%20id%3D%22toc-hId--2125354075%22%3EEXCEL%20Dashboard%3C%2FH3%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CP%20class%3D%22%22%3EHi%20Excel%20community%3C%2FP%3E%3CP%20class%3D%22%22%3E-%20I%20have%20this%20project%20I%20wish%20to%20implement%20at%20work%2C%20but%20I%20am%20kind%20of%20stock.%3C%2FP%3E%3CP%20class%3D%22%22%3E-%26nbsp%3B%20I%20have%20a%20database%20of%20clients%20who%20pick%20up%20medications%20from%20the%20facility%20periodically.%3C%2FP%3E%3CP%20class%3D%22%22%3E-%20I%20wish%20to%20build%20a%20dashboard%20where%20when%20I%20input%20the%20client's%20code%20(Personal%20ID)%2C%20excel%20gives%20me%20in%20return%20all%20the%20days%20the%20client%20came%20for%20pickup%20and%20the%20services%20he%20received%20each%20of%20these%20days.%3C%2FP%3E%3CP%20class%3D%22%22%3E-%20I%20have%20tried%2C%20but%20only%20succeeded%20to%20have%20a%20single%20day%20appear%20on%20my%20dashboard.%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3E-%26nbsp%3B%20I%E2%80%99ll%20be%20glad%20to%20hear%20from%20all%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2805752%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2805874%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20Dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2805874%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1169638%22%20target%3D%22_blank%22%3E%40Abaasanji%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20which%20Excel%20version%20%2F%20platform%20you%20are%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2805918%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20Dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2805918%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENo%20way%2C%20I%20still%20see%20users%20on%20Excel%202000%20and%20even%20on%20Excel%2097.%20That%20was%20nice%20time%20and%20we%20were%20younger.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

@Abaasanji 

On which Excel version / platform you are ?

@Abaasanji 

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.

@Hans Vogelaar 

No way, I still see users on Excel 2000 and even on Excel 97. That was nice time and we were younger. 

MS 2016
Thanks
Checking it now

@Sergei Baklan 

Yikes!