Feedback by UserVoice

How can we improve Excel for Mac?

Please create a function that will give you the Range (largest-smallest value)of a data set. ex.=range(a1:a13)

Please create a function that will give you the Range (largest-smallest value)of a data set. ex.=range(b1:b13).

More detail:
Sales person: (a1) a b c d e f g h i (j1)j
(b2) 11 12 9 13 12 13 3 2 14 (j2)1

=range(b2:j2) math: 13-1 answer: 12

Excel should look at only the highest and lowest digits within a given range and subtract the higher value from the lower.

3 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Joseph Grigoletti shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base