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 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago