Thread: Sorting rows
View Single Post
  #16   Report Post  
Old September 14th 13, 08:54 AM
Quilp Quilp is offline
Junior Member
 
First recorded activity by ExcelBanter: Aug 2013
Posts: 27
Default

Quote:
Originally Posted by Claus Busch View Post
Hi,

Am Fri, 13 Sep 2013 17:16:50 +0100 schrieb Quilp:

Column A shows the catalogue number I have allocated to the recording
(cd's, for example, have a label on them showing this number)


try:
=MAX(A:A)


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
I have been trying this function(?) but the results are confusing. If I try it in column A it works (not that I need to use it in this column because it is in sequential order) but when I use it in column B, which contains the same numbers but out of sequence following the sorting previously discussed, it returns zero. Is it the case that you cannot use the MAX function in columns that have been sorted? Or, perhaps it should be applied before sorting to make it work.