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
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago