Chi
New member
- Joined
- Jun 23, 2015
- Messages
- 29
- Reaction score
- 0
- Points
- 3
- Excel Version(s)
- excel 2013
Hi
I've attached a sample data, on the 'Data' tab, which shows in each cell a person's name, in short form or code, and a number, in bold, which denotes a placing number for each pairing of names.
Beside each pairing, highlighted in pink, shown on the 'Pairs' tab, I wanted a formula to show the total number of times that they came 1=1st, 2=2nd, 3=3rd only, ignoring the 0=no placings.
Just so you know, each person's name for each placing is listed with their own unique code on the 'Codes' tab which I would like to be incorporated in the formula. The reason being is that the listed names on the attached sample data only shows a small list of names and the formula(s) will eventually be used in a data with a vast number of names being approximately over 300 names.
So I guess using Countif formula would not be suitable for this vast data.
I hope this all makes sense and let me know if you have any queries about the attached data.
Kind regards
Chi
I've attached a sample data, on the 'Data' tab, which shows in each cell a person's name, in short form or code, and a number, in bold, which denotes a placing number for each pairing of names.
Beside each pairing, highlighted in pink, shown on the 'Pairs' tab, I wanted a formula to show the total number of times that they came 1=1st, 2=2nd, 3=3rd only, ignoring the 0=no placings.
Just so you know, each person's name for each placing is listed with their own unique code on the 'Codes' tab which I would like to be incorporated in the formula. The reason being is that the listed names on the attached sample data only shows a small list of names and the formula(s) will eventually be used in a data with a vast number of names being approximately over 300 names.
So I guess using Countif formula would not be suitable for this vast data.
I hope this all makes sense and let me know if you have any queries about the attached data.
Kind regards
Chi