You have the following chart that sorts states by the number of products each state has purchased.
Which formula should you use to Include a number with the position of each state within each region?
TDA-C01 Exam QuestionsBrowse all questions from this exam
TDA-C01 Exam - Question 52
Show AnswerHide Answer
Correct Answer: C
To include a number with the position of each state within each region, the correct formula to use is INDEX(). INDEX() provides the position of each row in the partition, which can be modified and reset based on the region in this case. This way, each state will be assigned a unique position number within its respective region.
Discussion
2 comments88c0ad8Option: C
May 10, 2024It's INDEX()
MonBoujOption: C
Jun 2, 2024C. INDEX()
MonBouj
Jun 2, 2024sorry it should be B B. LOOKUP(SUM([Quantity]))