 |
 | 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 / General Excel Questions / February 2008excell worksheet function
how do I find the location of a particular item in a worksheet? For example, if I have a spreadsheet showing the last 30 years of sales production how could I find the cell location of the highest or lowest figure? Use MATCH in conjunction with MIN or MAX to get the (relative) row, such as: =MATCH(MAX(S1:S2000),S1:S2000,0) =MATCH(MIN(S1:S2000),S1:S2000,0) assuming sales figures are within the range S1:S2000. Hope this helps. Pete > how do I find the location of a particular item in a worksheet? For > example, > if I have a spreadsheet showing the last 30 years of sales production how > could I find the cell location of the highest or lowest figure? |
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.