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?
  • 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