> > >

Excel MCQs

Count unique text values in a range, Choose formula?

=SUMPRODUCT(--(FREQUENCY(MATCH(data,data,0),ROW(data)-ROW(data.firstcell)+1)>0))

=SUMPRODUCT(--(FREQUENCY(MATCH,data,data,0),ROW(data)-ROW(data.firstcell)1)>0))

=SUMPRODUCT(--(FREQUENCY(MATCH(data,data,0),ROW(data)-ROW(data.firstcell +1)>0)

=SUMPRODUCT(--(FREQUENCY(MATCH(data,data,0),ROW(data,-ROW(data.firstcell)+0)>1))

Answer

Correct Answer: =SUMPRODUCT(--(FREQUENCY(MATCH(data,data,0),ROW(data)-ROW(data.firstcell)+1)>0))

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it