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?
Johanna Reilly's avatar
Johanna Reilly
Copper Contributor
Apr 01, 2019

I just want to find the total number of people who have a change of city on the spreadsheet Twifoo