Forum Discussion
Help on calculation by date
Hello, I need help on how to count number of tickets open 12 weeks befora and 12 weeks after a certain date in Excel. The trouble is tickets should be counted by device id where ticket id is unice va...
=COUNT(UNIQUE(FILTER(B2:B27,(C2:C27>=H2)+(C2:C27<=I2))))
Is this what you are looking for? The formula returns the number of unique device id numbers 12 weeks before and 12 weeks after a certain date as shown in the attached file.
- Thanks a lot, but I wasn't succesfull I'm afraid.. I've attached an example of the report I need to populate, the number of ticket per device before and after certain date, but to add more details, that certain date will change (entered date field) and the raw data I need to use has ticket as unique values but number of devices are duplicate meaning there are more than one ticket opened for each device and I need calculation per specific device in calc sheet hope this makes sense:-)
