hi excelers,
How do I find the distance between Max to Min values in array?
bit complex to write so here's a simple example:
1
2
3
4
5
= 3
(cuz the distance between 1 (Min number) and 5 (Max number) is array cells 3
another example
6
11
4
3
8
= 1
(cuz the distance between 3 (Min number) and 11 (Max number) in array cells is 1
thx for any suggestions and please keep your solution as short & simple as possible*
Bookmarks