Hello - I need help fast.
I have a large spreadsheet that looks like this:
A2 = Customers
B2 = Oranges
C2 = Apples
D2 = Grapes
E2 = Bananas
F2 = Kiwi

I need a report that shows:
How many have Oranges only?
How many have Apples only?
How many have Grapes only?
etc.

I also need a report that ranks the customer by the most number of Kiwi's,
while still showing the count of the other fruits.

Please help!