Rae,

Nope. Neither one of your suggestions panned out. Very strange.


"Rae Drysdale" wrote:

I would have thought it would be to do with the formatting as text. Format as
Number and run the formula again. Also I would retype the figure 3150 again
just in case!
--
Rae Drysdale


"Phil" wrote:

Hello,

I have a column (col A) with numbers (formatted as text) which are normally
in sequential series order from 1 to 3150 (but growing every day).
Sometimes, I have to sort the spreadsheet based on an another columns
criteria, and consequently the order from the first column A is not in
sequence anymore. When I run the =MAX(A2:A3151), it returns 3145, which as I
have just discovered, is missing in the series. Nonetheless, it should have
identified 3150 as the highest number, right?

Or does the fact that the 3145 value is missing from the selection set have
to do anything?

I then copied to column over, changed the format to General, and the MAX
returned the same result, 3145, no difference.

Just to see if there was a problem with Excel, I then ran the MAX function
on a new blank spreadsheet with some test values, and it worked. When that
worked, I inserted a new column (B) in the spreadsheet that is giving
trouble, and inserted some random values, ran the MAX function, and it works.
And they are not in sequence, nor are they contigous.

Any idea why this is happening?