9.9999E+307+?

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Seti

Well-known Member
Joined
May 19, 2002
Messages
2,916
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

MrExcel MVP
Joined
Feb 17, 2002
Messages
3,853
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

Legend
Joined
Sep 3, 2002
Messages
10,473
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
ABCD
11113
222
333
444
555
667
778
889
999
10456
11678
12
13999
14but
15not
16these
Sheet2
 

DRJ

MrExcel MVP
Joined
Feb 17, 2002
Messages
3,853

ADVERTISEMENT

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

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

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
DRJ said:
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

Well-known Member
Joined
Feb 20, 2004
Messages
1,070

ADVERTISEMENT

Thank, body.
 

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
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

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,304
Messages
5,600,862
Members
414,409
Latest member
FloordAlex

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top