Type a code that will look into these 7 colum

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I have one sheet in which i have 7 columns.
In each column different ranges are typed by me i.e 580, 790, 450....
so i want in my other excel sheet to use a formulae or type a code that will look into these 7 columns & provide me highest range or lowest range...
pls tell....



1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
"highest range or lowest range.."
what is the interpretation of these terms

1.find the range (maximum - minimum in that column) for each column and find the highest range and lowest range irrespective of column

2. maximum and minimum in each column

give one or two examples