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 48 weeks ago
6 years 33 weeks ago
6 years 45 weeks ago
6 years 48 weeks ago
6 years 49 weeks ago
7 years 2 weeks ago
7 years 11 weeks ago
7 years 11 weeks ago
7 years 11 weeks ago
7 years 11 weeks ago