Please... I Need help on Excel formula!
Hi all, I have 3 classes with around 60 students in total. I am going to distribute a white shirt to each of them for a group event. The shirts were printed with number on the back (e.g. 1 to 60).
Now, what formula should I use to determine what is the major color in each group?
For instance,
Group A 1 2 5 4 10 Majority:Green
Group B 3 19 7 11 12 Majority:Blue
Group C 13 19 16 14 17 Majority:Blue
Group D 8 9 15 6 20 Majority: Green
1 Blue
2 Green
3 Blue
4 Green
5 Blue
6 Green
7 Blue
8 Green
9 Blue
10 Green
11 Blue
12 Green
13 Blue
14 Green
15 Blue
16 Green
17 Blue
18 Green
19 Blue
20 Green
Please assist on this matter, thank you!
Recent comments
6 years 6 weeks ago
6 years 44 weeks ago
7 years 3 weeks ago
7 years 6 weeks ago
7 years 7 weeks ago
7 years 13 weeks ago
7 years 21 weeks ago
7 years 21 weeks ago
7 years 21 weeks ago
7 years 21 weeks ago