Tag Archives: COUNTIF

Rank in subgroup… RANKIF?

To get the overall ranking is easy with the RANK function.  The syntax of RANK =RANK(Number,Ref,[order]) Number is the number we want to rank; Ref is the list of numbers of comparison (could be an array, a reference or a list … Continue reading

Rate this:

Posted in Formula | Tagged , , | Leave a comment

VLOOKUP the Nth matched item, with helper column

This should be the last post in 2015.  So it’s better to answer unanswered question in the year.  🙂 Question: “VLOOKUP will return the first matched value found, in case there are multiple matched records what formula should we use?” This … Continue reading

Rate this:

Posted in Formula | Tagged , | Leave a comment

15-significant-digit issue with SUMIF(S), COUNTIF(S), AVERAGEIF(S)

Have you applied SUMIF or COUNTIF to a range that contains numbers with more than 15 digits stored as text? If you did or if you do, you’d better continue to read this as you’ve got wrong answers that you … Continue reading

Rate this:

Posted in Formula | Tagged , , , , | 3 Comments