CODEWITHSUNDEEP
excel
Emeline
Emeline

Reputation: 171

Excel - Compute number of people by group

I have a table in Excel. I would like to know if among a group ("Fruits") every fruit type was planted by the same person or not.

For example, in the following table, all apricots and blueberries were planted by the same people while strawberries were planted by different people.

Fruit        Planted by   Day
Apricots     Amanda       01/07
Apricots     Amanda       02/07
Apricots     Amanda       03/07
Strawberries Kevin        01/07
Strawberries Amanda       01/07
Blueberries  Emily        02/07
Blueberries  Emily        03/07

So I would like a case like this at the end:

Who             Number of plantation
Only Amanda      1
Only Kevin       0
Only Emily       1
Amanda and Kevin 1
Amanda and Emily 0
Kevin and Emily  0

How can I do that?

Thank you!

Upvotes: 0

Views: 68

Answers (1)

Ozgun Senyuva
Ozgun Senyuva

Reputation: 466

Maybe the pivot table below can help you. You will see more than one record for each fruit, if a fruit planted by two or more.

.

Upvotes: 1

Related Questions