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
(thinking…)
Sign in with: facebook google
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
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base