LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How do I return the cell location

How do I return the cell location (in addition to the value contained in the
cell) of the maximum value in an Excel array?

I'm trying to locate the row number for the maximum value in a column of
numbers.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I return tthe location (cell) when using the max function Holke Excel Discussion (Misc queries) 6 March 11th 07 01:27 AM
Return the Row of a Variable's location xjetjockey Excel Discussion (Misc queries) 1 December 22nd 06 11:52 PM
Hyperlink or Other Method To Return To Previous Location (Sheet) Possible? Mhz New Users to Excel 4 August 1st 06 11:39 AM
How to return a specific data point from a large array if I don't know the exact location? [email protected] Excel Discussion (Misc queries) 4 May 2nd 06 03:54 PM
Is there a function that will return info of the cursor location? cbre_bryork Excel Worksheet Functions 3 May 15th 05 02:02 AM


All times are GMT +1. The time now is 03:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"