battlingwithexcel
Board Regular
- Joined
- Dec 22, 2011
- Messages
- 82
Hi,
I have a list of countries in column c of a worksheet and a list of names in column d. This list contains many duplicates and I basically want to have a total count of any unique county and name combo i.e. The list might look like:
UK John
UK Bob
UK John
France Hannah
I would like to have a total of 3 in this case... Can anyone help me with a formula for this?
I have a list of countries in column c of a worksheet and a list of names in column d. This list contains many duplicates and I basically want to have a total count of any unique county and name combo i.e. The list might look like:
UK John
UK Bob
UK John
France Hannah
I would like to have a total of 3 in this case... Can anyone help me with a formula for this?