 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2005max of non adjacent columns
I have 12 columns with numbers,these numbers change very rapidly as they are fed into the sheet from a website. I need a formula to calculate the max of the numbers in every second column,for the first row this would be the numbers in cells B1,d1,f1,h1,j1,l1. The answer will be stored in another cell,and of course will be constantly changing as the contents of these cells change.  Signaturepytelium What is wrong with MAX(B1,D1,F1,H1,J1,I1) ? As you copy it down the column it will adjust to (on row 2) MAX(B2,D2,F2,H2,J2,I2) best wishes SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > I have 12 columns with numbers,these numbers change very rapidly as they > are fed into the sheet from a website. [quoted text clipped - 3 lines] > The answer will be stored in another cell,and of course will be > constantly changing as the contents of these cells change. =MAX((MOD(COLUMN(B1:L1),2)=0)*(B1:L1)) entered with ctrl + shift & enter SignatureRegards, Peo Sjoblom > I have 12 columns with numbers,these numbers change very rapidly as they > are fed into the sheet from a website. [quoted text clipped - 3 lines] > The answer will be stored in another cell,and of course will be > constantly changing as the contents of these cells change. Yes,both these solutions work.Thank you. I have a related question. I want to create an IF statement to print True if the largest of the six cells is more than 5 times the second largest,otherwise print false. Signaturepytelium Always better to start a new thread when you have a new question. Either =IF(MAX(A1:A6)>5*LARGE(A1:A6,2),"True","False") or =MAX(A1:A6)>5*LARGE(A1:A6,2) The first gives a text result, the second a Boolean TRUE/FALSE result BTW: formulas "return" or "display" results; not "print" best wishes SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > Yes,both these solutions work.Thank you. I have a related question. I > want to create an IF statement to print True if the largest of the six > cells is more than 5 times the second largest,otherwise print false. =large() can return the largest (max), second largest, ... value from a range. But since your range is discontiguous, you have to be careful when you use it: =MAX(B1,D1,F1,H1,I1,J1)>(5*LARGE((B1,D1,F1,H1,I1,J1),2)) watch those parentheses inside the large function. > Yes,both these solutions work.Thank you. I have a related question. I > want to create an IF statement to print True if the largest of the six [quoted text clipped - 5 lines] > pytelium's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25521 > View this thread: http://www.excelforum.com/showthread.php?threadid=496773 SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.