Hi folks,
I am wondering is there a way to summarise the table below so that it lets me know if an event had only newcomers, only returns, or returns and newcomers.
For instance, I am trying to distill this table down to:
On 11/11/19, the "Shop" had "New and Return" customers while the "Show" had only "Return" customers and the "Online" customers were all "new".
I'm not sure if this can be done with a pivot table or by using a mixture of formulas, but I've spent a couple of hours trying to figure this out!
Many thanks in advance,
Dave
[TABLE="width: 224"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 277"]
<tbody>[TR]
[TD]Type[/TD]
[TD]Event[/TD]
[TD] Date[/TD]
[/TR]
[TR]
[TD]New[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]New[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]Walk-in New[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]Walk-in New[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]Return[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]Return[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]Return[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]Return[/TD]
[TD]Show[/TD]
[TD="align: right"]
[/TR]
[TR]
[TD]
[TD]Show[/TD]
[TD="align: right"]
[/TR]
[TR]
[TD]
[TD]Show[/TD]
[TD="align: right"]
[/TR]
[TR]
[TD]
[TD]Show[/TD]
[TD="align: right"]
[/TR]
[TR]
[TD]
[TD]Show[/TD]
[TD="align: right"]
[/TR]
[TR]
[TD]Return[/TD]
[TD]Show[/TD]
[TD="align: right"]
[/TR]
[TR]
[TD]New[/TD]
[TD]Online[/TD]
[TD="align: right"]
[/TR]
[TR]
[TD]New[/TD]
[TD]Online[/TD]
[TD="align: right"]
[/TR]
[TR]
[TD]New[/TD]
[TD]Online[/TD]
[TD="align: right"]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
I am wondering is there a way to summarise the table below so that it lets me know if an event had only newcomers, only returns, or returns and newcomers.
For instance, I am trying to distill this table down to:
On 11/11/19, the "Shop" had "New and Return" customers while the "Show" had only "Return" customers and the "Online" customers were all "new".
I'm not sure if this can be done with a pivot table or by using a mixture of formulas, but I've spent a couple of hours trying to figure this out!
Many thanks in advance,
Dave
[TABLE="width: 224"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 277"]
<tbody>[TR]
[TD]Type[/TD]
[TD]Event[/TD]
[TD] Date[/TD]
[/TR]
[TR]
[TD]New[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]New[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]Walk-in New[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]Walk-in New[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]Return[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]Return[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]Return[/TD]
[TD]Shop[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]Return[/TD]
[TD]Show[/TD]
[TD="align: right"]
11/11/2019
[/TD][/TR]
[TR]
[TD]
Return
[/TD][TD]Show[/TD]
[TD="align: right"]
11/11/2019
[/TD][/TR]
[TR]
[TD]
Return
[/TD][TD]Show[/TD]
[TD="align: right"]
11/11/2019
[/TD][/TR]
[TR]
[TD]
Return
[/TD][TD]Show[/TD]
[TD="align: right"]
11/11/2019
[/TD][/TR]
[TR]
[TD]
Return
[/TD][TD]Show[/TD]
[TD="align: right"]
11/11/2019
[/TD][/TR]
[TR]
[TD]Return[/TD]
[TD]Show[/TD]
[TD="align: right"]
11/11/2019
[/TD][/TR]
[TR]
[TD]New[/TD]
[TD]Online[/TD]
[TD="align: right"]
11/11/2019
[/TD][/TR]
[TR]
[TD]New[/TD]
[TD]Online[/TD]
[TD="align: right"]
11/11/2019
[/TD][/TR]
[TR]
[TD]New[/TD]
[TD]Online[/TD]
[TD="align: right"]
11/11/2019
[/TD][/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]