LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Finding a cell location

I am trying to find the exact cell reference (or even column) that contains
the max of a range.
Basically, after I find the highest or lowest of a range, I want to be able
to identify which column it's in and then display that column heading in
another cell.
 
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
Finding the Location within an Array Sh0t2bts Excel Worksheet Functions 2 December 5th 07 01:06 PM
Finding the location of what was summed [email protected] Excel Worksheet Functions 3 May 21st 07 08:15 PM
Finding the location of MAX value in column milly Excel Discussion (Misc queries) 2 May 11th 07 12:15 PM
finding cell location Jshendel Excel Discussion (Misc queries) 5 August 30th 06 10:02 PM
finding rightmost location of a character KingGeezer Excel Worksheet Functions 9 January 24th 06 05:21 PM


All times are GMT +1. The time now is 04:23 AM.

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

About Us

"It's about Microsoft Excel"