Forum Discussion

Johanna Reilly's avatar
Johanna Reilly
Copper Contributor
Apr 01, 2019

counting duplicates with several conditions

Hi I have data that looks like this: ID City 1 Glasgow 2 Dundee 3 Edinburgh 3 Edinburgh 3 Dundee 4 Glasgow 4 Glasgow 4 Glasgow 5 Edinburgh 6 Dundee 6 ...
excel
Twifoo's avatar
Twifoo
Silver Contributor
Apr 01, 2019
For example, what results do you expect to be returned by the formula in Column C?
Twifoo's avatar
Twifoo
Silver Contributor
Apr 01, 2019
In your sample data, what specific result do you expect as the answer to your question?