I have a spreadsheet will data regarding service calls that my company has made. I also have a table showing the top reasons for these calls separated out by day. I have a formula that counts how many of each reason occurred on a day. In addition to displaying the count, I would like the formula to display the call numbers that happened on that day. Is this possible? For example, say on November 20, I have calls 1234 and 4567 (both calls were generated for the same reason). Right now, my formula will tell me that 2 calls were made on November 20. I would like it to tell me that 2 calls were made on November 20 and they are 1234 and 4567. Is that possible?
Here is the formula that I am currently using: =COUNTIFS('Note (1)'!$E:$E, 'Frequency for Top Units'!B22, 'Note (1)'!$D:$D, 'Frequency for Top Units'!$C$3, 'Note (1)'!$J:$J, 'Frequency for Top Units'!$B$19)
Any assistance you can provide would be greatly appreciated.
Here is the formula that I am currently using: =COUNTIFS('Note (1)'!$E:$E, 'Frequency for Top Units'!B22, 'Note (1)'!$D:$D, 'Frequency for Top Units'!$C$3, 'Note (1)'!$J:$J, 'Frequency for Top Units'!$B$19)
Any assistance you can provide would be greatly appreciated.