Range of data

JinwonK

Hello, I'm looking for a simple, at a glance range of data.

• Example, column contains numbers from 150 to 4, with 23 rows (more rows be added as completed) that are from formula.
  • List of 2 numbers: Largest and Lowest numbers.
  • List of spread Large to Low and vice versa.
• I tried RANKEQ formular, but unable to make it work. See attached snip. Unsure am doing the right way… What to do?
  

Thanks,

Michelle Choate 2

Cause

The formula contains or references an incompatible data type, such as =INT("Hello")

Resolution

Make sure the formula references the correct data type.

I think the issue here is that you have your information backwards:

=RANKEQ([Primary Column]@row, {Day to Submit to Comp},0)