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 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 34 weeks ago
6 years 36 weeks ago
6 years 41 weeks ago
6 years 49 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago