Nelson78
Well-known Member
- Joined
- Sep 11, 2017
- Messages
- 526
- Office Version
- 2007
Hello everybody.
I've a situation like the following:
column f column g
A ONE
A ONE
A TWO
A THREE
A THREE
B ONE
B ONE
B ONE
B TWO
A FOUR
A FOUR
A FOUR
A FOUR
A FIVE
I need a formula that counts how many differents values in column g for the value A in column f (in the example 5) and how many different values in column g for the value B in column f (in the example 2).
Thank you.
I've a situation like the following:
column f column g
A ONE
A ONE
A TWO
A THREE
A THREE
B ONE
B ONE
B ONE
B TWO
A FOUR
A FOUR
A FOUR
A FOUR
A FIVE
I need a formula that counts how many differents values in column g for the value A in column f (in the example 5) and how many different values in column g for the value B in column f (in the example 2).
Thank you.