GSheets: trying to count if a text value appears more than once-CodePudding

Home > database > GSheets: trying to count if a text value appears more than once

GSheets: trying to count if a text value appears more than once

Time：11-20

I can't figure out a way to count the number of repeat purchases from an order report, based on unique emails. I made a helper column to TRUE/FALSE if an email appears more than once in the range. But how can I count the number of "TRUE"?

Attached is a very small sample of my data set with only 3 customers. I need to do for over 10,000 customers.

Page link：https//www.codepudding.com/database/198489.html

Prev:Display query result in one row instead of two column Google Sheets

Next:Counting nth occurrence of a value

Tags：

google-sheets

google-sheets-formula

spreadsheet

Links：
CodePudding