LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Max (A1:A1), relating to other cells

Ive got Max A:A, which returns the maximum number in column A. How can i
get another cell to show the data from column B, which is pulled from
the same row as the result of Max A:A.




--
Mark


http://www.mozilla.com/firefox/ - Firefox Rules!
http://fireftp.mozdev.org/ - FTP Plugin for Firefox
http://ietab.mozdev.org/ - IE tab. Get Windows updates in Firefox
 
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
Relating cells PaulinaDi Excel Worksheet Functions 3 October 17th 06 08:44 PM
Relating fields Henk Excel Discussion (Misc queries) 1 May 29th 06 11:33 AM
Relating text to a value SociologyStudent Excel Worksheet Functions 1 May 11th 06 04:17 AM
Relating text to a value SociologyStudent Excel Worksheet Functions 5 May 10th 06 08:21 PM
Problem with an "if" relating to a range Anthony Excel Worksheet Functions 7 July 10th 05 05:46 AM


All times are GMT +1. The time now is 12:00 PM.

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"