Thread: Sorting rows
View Single Post
  #15   Report Post  
Old September 13th 13, 06:01 PM posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,651
Default Sorting rows

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