[Solved] Count of times the email appears

[krotkolapka]

Hi, Beautiful Creatures!

I have a big database with reservations.
Every row is one reservation.
Some of them are accepted and some of them are cancelled.

The rows look like this:
ACCEPTED | EMAIL ADDRESS 1 | DETAILS
ACCEPTED | EMAIL ADDRESS 2 | DETAILS
CANCELLED | EMAIL ADDRESS 1 | DETAILS
etc.

I would like to automatically count how many times the particular email address appears for accepted and cancelled reservations.

So the output would be:
EMAIL ADDRESS 1 | accepted: 7 | cancelled: 5

I was wondering how to solve this dilemma. Any ideas? I will really appreciate your help!

[karolus]

Hallo

Try →→Data→(DataPilot aka Pivottable)

drag&drop firstColumn to ColumnField, drag&drop second column to RowField AND also into DataField( choose Count instead Sum )