View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Solesbury Mark Solesbury is offline
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