RANGK.EQ in WPS on Windows FAQ

Last updated:July 20, 2026

Common questions about RANGK.EQ usually focus on formula entry, ranking order, unexpected results, and fill-down behavior; this section answers 4 frequent questions.

FAQ

Why does RANGK.EQ not return a result after I enter it?

  1. Check whether the formula starts with =.
  2. Check whether the parentheses, commas, and cell references are complete.
  3. Make sure the target cell is not formatted as text. If needed, change it to a general format and enter the formula again.

How do I tell ascending and descending order apart in RANGK.EQ?

  1. If you omit the third argument or enter 0, the formula usually returns descending rank order.
  2. If you enter 1, the formula returns ascending rank order.
  3. Review the result to confirm it matches your ranking goal.

Why are the results incorrect after I fill the formula down?

  1. Check whether the comparison range uses an absolute reference such as $A$2:$A$10.
  2. Confirm the first-row formula is correct before filling down.
  3. If the range shifted, lock the range again and refill the formula.

Why did the ranking not change as expected after the data was updated?

  1. Check whether the new or edited values are included in the referenced range.
  2. Make sure the cells used in the calculation contain numeric values.
  3. Review the order argument to confirm the ascending or descending setting matches your expectation.

Glossary

TermDefinition
RANGK.EQA ranking function in WPS Spreadsheet that returns the position of a value within a data range.
Absolute referenceA reference style that uses $ to lock rows and columns so the comparison range stays fixed when the formula is filled down.
Order argumentThe third argument in RANGK.EQ that controls whether the result uses descending or ascending ranking.
Comparison rangeThe group of cells used as the reference set for ranking.