9.9999E+307+?

[dennisli]

In Excel, 9.9999E+307 = ?
Thanks

 

[Seti]

In Excel help under Microsoft Excel Specifications,

Largest allowed positive number is 9.99999999999999E307

so if you are trying to find the largest value, it can not be any greater than 9.99999999999999E307.

 

[DRJ]

That is a pretty big number. I mean a google is only 10^100 So this is a google * google * google. I don't think you would need a bigger number for anything. The total numbers of atoms in the universe is less than one google.

 

[just_jon]

Often a named value called BigNum. You can use it, for example, to determine the end of a numeric range of data as in the below example --

Book1
	A	B	C	D
1	11		13
2	22
3	33
4	44
5	55
6	67
7	78
8	89
9	99
10	456
11	678
12
13	999
14	but
15	not
16	these
Sheet2

 

[DRJ]

Or you could just use Max(A:A) to find the largest value

Or Match(Max(A:A),A:A)

 

[Aladin Akyurek]

Or you could just use Max(A:A) to find the largest value

Or Match(Max(A:A),A:A)

And you think that's the same thing as:

[1]

=MATCH(9.99999999999999E+307,A:A)

but it's not.

You can of course try:

[2]

=MATCH(MAX(A:A)+1,A:A)

However, [2] introduces an additional functional call, therefore it doesn't match the speed of [1].

 

[dennisli]

Thank, body.

 

[GorD]

Jon, I think your post being in numeric order as thrown a few folk. But I may be mistaken as I have only picked up this technique of you guys in the last 2 months.

My understanding which I believe you say is that the 9.9999.... will find the last numeric entry in a range, where as the max one will find the occurence of the largest value within the range. not the same.

Or have I got this wrong?

 

[GorD]

Okay, I've checked the match formula and it seems to give the last numeric value as well. Teach me not to check it first.