Thread: Sorting rows
View Single Post
  #18   Report Post  
Old September 15th 13, 08:53 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 Sat, 14 Sep 2013 08:54:32 +0100 schrieb Quilp:

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.


if the MAX function returns 0 your numbers are text formatted.
Write a 1 in an empty cell, copy this cell, select all numbers in column
B, Insert = Paste Special = Multiply


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
The PlanMaker Paste Special is, I suspect, different to Excel and I am unable to follow your instruction. It seems that I will have to use the extra column A, containing the sequential numbers, in order to locate the last.
I should not really be using this forum because I do not have Excel but it is so much better than the PlanMaker forums. Thanks for all your help Claus - it is much appreciated. Perhaps one day, if you have nothing better to do, you could download the free version of PlanMaker and see if you can resolve this MAX problem!
Regards
Quilp