Type a code that will look into these 7 colum

Closed
Tushar - Oct 12, 2011 at 11:42 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 13, 2011 at 12:07 AM
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....



Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 13, 2011 at 12:07 AM
"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
0