Using arrayformula with countuniqueifs

[delustrous]

Hi All,

I have a dataset in the worksheet labeled “data”. This data has information on respondents with a unique ID—uniqueid (column C), submisiondate (column A), id of submitter—submitterid (column B), and the outcome of the survey—outcome (column D).

I want to create a matrix on another worksheet labeled “report”. Here, I want to count the number of unique submissions by each submitter and across different submission dates. In doing so, I want to count only unique submissions by submitter per day. The submitterid is on the vertical axis of the worksheet while the dates are on the horizontal axis.

I have attached the excel sheet for your perusal.

I would like to use arrayformula to display the number of unique submissions by submitter per day. Could anyone please help me? I don't have an idea about how to do this.

Thanks in advance.

 

[kweaver]

You cannot attach a spreadsheet/workbook. Best you use XL2BB to illustrate a few examples of what you have and what you want.