Problem w/ values being given

Hijrofoyle

New Member
Joined
Oct 7, 2002
Messages
35
Hey, I've got a data sheet with around 26 colums and 30,000 rows, when i ask for the max number in one of the colums it gives me 3.4400E+00 every time, but i sorted the colums in ascending order and that value isn't in one of the colums. largest value is on the order of .5
any help would be greatly appreciated. You may email me directly
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Are you referencing the entire column in your MAX function [e.g., =MAX(C:C)]? If so, are you sure that your inordinately large value doesn't reside on a row beyond your 30,000 sorted rows (separated by one or more empty rows)?
 

Hijrofoyle

New Member
Joined
Oct 7, 2002
Messages
35
Nah, max(A14:A29000) or something similar, no gaps in the rows as near as i can tell
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
On 2002-10-09 04:15, Hijrofoyle wrote:
Nah, max(A14:A29000) or something similar, no gaps in the rows as near as i can tell

So, if you select cell A14 and choose the Edit | Go To... [Special...] menu command's "Current region" option row 29000 is included in the selection?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,400
Messages
5,601,462
Members
414,451
Latest member
jrose7

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