Hi there,
I am using the COUNTIF formula to count the different cells to get a final amount. While this is counting everything correctly and giving me the correct final amount, I wish to have all the cells that have been counted to be linked to the final value cell (when it is double clicked, to provide detailed data on the values). Let me explain further to make this make sense.
This is what the final inventory count table is going to look like:
The data from my source looks like this:
What I'm doing is:
- Counting the amount of orders that will meet the criteria from the source data to populate the inventory count table. For example, in the source data, if "Create Date (Week)" is equal to "Week 3", it will tell me how many times "Week 3" comes up in the entire column.
Here is what I want to build on:
- As we can see, "Week 3" comes up twice in the source data under the "Create Date (Week)" column. This will populate the cells merging "New Escalations" and "Week 3" in the inventory count table with "2" (ie. cell C2). What I wish to have is the intelligence / functionality to have the 2 rows that had "Week 3" linked to the cell that says "2". Thus, if somebody clicks the 2, it will open up a new worksheet / same worksheet with the two data points (so it will provide the detailed data pertaining to the value).
I am really desperate for help with this problem. Can you please let me know if this is possible? How can I go about it? Is there another approach I should be using? PLEASE help me - anything will be appreciated!!
I am using the COUNTIF formula to count the different cells to get a final amount. While this is counting everything correctly and giving me the correct final amount, I wish to have all the cells that have been counted to be linked to the final value cell (when it is double clicked, to provide detailed data on the values). Let me explain further to make this make sense.
This is what the final inventory count table is going to look like:
Week 4 | Week 3 | Week 2 | Week 1 | |
New Escalations | 2 | |||
Resolved Escalations | ||||
Active Escalations |
The data from my source looks like this:
Order # | Customer Name | Reason Code | Status | Comments | Create Date | Create Date (Week) | Resolution Date | Resolution Date (Week) |
1 | First Code | Complete | Misc. | 1-Jan-20 | Week 1 | 1-Feb-20 | Week 5 | |
2 | Company 2 | Second Code | Complete | Misc. | 15-Jan-20 | Week 3 | 12-Feb-20 | Week 7 |
3 | Company 3 | First Code | Complete | Misc. | 17-Jan-20 | Week 3 | 2-Feb-20 | Week 5 |
4 | Company 4 | Third Code | Active | Misc. | 1-Feb-20 | Week 5 | ||
5 | Company 5 | Second Code | Active | Misc. | 10-Feb-20 | Week 7 |
What I'm doing is:
- Counting the amount of orders that will meet the criteria from the source data to populate the inventory count table. For example, in the source data, if "Create Date (Week)" is equal to "Week 3", it will tell me how many times "Week 3" comes up in the entire column.
Here is what I want to build on:
- As we can see, "Week 3" comes up twice in the source data under the "Create Date (Week)" column. This will populate the cells merging "New Escalations" and "Week 3" in the inventory count table with "2" (ie. cell C2). What I wish to have is the intelligence / functionality to have the 2 rows that had "Week 3" linked to the cell that says "2". Thus, if somebody clicks the 2, it will open up a new worksheet / same worksheet with the two data points (so it will provide the detailed data pertaining to the value).
I am really desperate for help with this problem. Can you please let me know if this is possible? How can I go about it? Is there another approach I should be using? PLEASE help me - anything will be appreciated!!