Hello World,
I think I have a challenge here, or maybe this is an excel limitation. I need to count the unique Ticket Numbers (Column B) for a given month / date range (Column E), but also segregate it out by Place (Column D) uniquely. The table to the left is the source of the information and variables, while the table on the left with the months and place numbers are the results. I also have excel 2007.
Thank you and good luck to anyone that can help
<tbody>
</tbody>
I think I have a challenge here, or maybe this is an excel limitation. I need to count the unique Ticket Numbers (Column B) for a given month / date range (Column E), but also segregate it out by Place (Column D) uniquely. The table to the left is the source of the information and variables, while the table on the left with the months and place numbers are the results. I also have excel 2007.
Thank you and good luck to anyone that can help
Ticket Number | Company | Place | Start Date | End Date | Place1 | Place2 | ||
1 | Company1 | Place1 | 1/1/2015 | 1/2/2015 | January | 2 | 1 | |
1 | Company2 | Place1 | 1/1/2015 | 1/2/2015 | Febuary | 1 | 1 | |
2 | Company3 | Place2 | 1/2/2015 | 2/1/2015 | ||||
3 | Company2 | Place1 | 1/2/2015 | 1/3/2015 | ||||
4 | Company2 | Place1 | 2/1/2015 | 2/2/2015 | ||||
5 | Company2 | Place2 | 2/8/2015 | 2/9/2015 |
<tbody>
</tbody>