You have a dataset that contains people and the awards they have won. Which formula should you use to get the number of different types of awards that have been won?
To get the number of different types of awards that have been won, you should use the following formula:
**B. COUNTD([Award])**
This formula counts the distinct values in the "Award" field, giving you the number of different types of awards.
Source: Conversation with Copilot, 6/7/2024
(1) . https://www.sportsnet.ca/hockey/juniors/calgary-hitmen-honour-2019-2020-award-winners/.
(2) https://www.stpaulstrust.org.uk/st-pauls-school-year-11-leavers-message-2019-2020. https://www.stpaulstrust.org.uk/st-pauls-school-year-11-leavers-message-2019-2020/.
(3) https://www.techpointyouth.org/blog/2019/3/13/2019-indiana-vex-robotics-state-championship. https://www.techpointyouth.org/blog/2019/3/13/2019-indiana-vex-robotics-state-championship.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Benzlover
5 months, 3 weeks agoMonBouj
6 months agoJUT_TC
1 year, 2 months ago