• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hyperlink with filter or passing criteria

dnessim

Member
Hi all,
I have googled this question and not come up with a solution that fits my needs yet.
I have a dashboard with hospital readmission rates, basically numerators, denominators and %rate values , for each quarter of the year.
What my question is how can I make the values link to another worksheet that has the results filtered. Each hyperlink has a different criteria.
Thanks
dave
 
Here is a simple example of what I am trying to.
I have a column of data, Hospital readmissions. There are 6 values in this column
Hospital readmissions
7
12
9
4
7
2


The formula to calculate each value looks like this:
Code:
=COUNTIFS(Facility,$A3,Discharge_Month,">=1",Discharge_Month,"<=3",Readmit_Month,">=1",Readmit_Month,"<=4",UniqueCount,0)


Is there a way to create a hyperlink from each of these values to a worksheet that actual shows these records?
So if I click on the number 7 , I want to show the 7 records that are returned from the above formula?
Thanks
Dave
 
Back
Top