 |
 | 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 / Worksheet Functions / February 2008split cells with each having a formula possible?
Want data table cell with the maximum and minimum values of another page to show as a/b in a cell. Is this possible? Forgot to mention using Winxp with Excel 2002. "drb" <drburdiX@pacbell.net> wrote in message news:... > Want data table cell with the maximum and minimum values of another page > to show as a/b in a cell. Is this possible? Don't have a clue what you're talking about. Perhaps you could show an example. Tyro > Want data table cell with the maximum and minimum values of another page > to show as a/b in a cell. Is this possible? A/B A = max B = min =MAX(Sheet2!A1:A10)&"/"&MIN(Sheet2!A1:A10)  SignatureBiff Microsoft Excel MVP > Want data table cell with the maximum and minimum values of another page > to show as a/b in a cell. Is this possible? Excellent, excellent. Exactly what I needed. THANK YOU. > A/B > [quoted text clipped - 5 lines] >> Want data table cell with the maximum and minimum values of another page >> to show as a/b in a cell. Is this possible? You're welcome. Thanks for the feedback! SignatureBiff Microsoft Excel MVP > Excellent, excellent. Exactly what I needed. THANK YOU. > [quoted text clipped - 7 lines] >>> Want data table cell with the maximum and minimum values of another page >>> to show as a/b in a cell. Is this possible? |
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.