Microsoft Office Forums - View Single Post - How to obtain maximum value of an excel column with a large range?

Thread: How to obtain maximum value of an excel column with a large range?

View Single Post

Old

02-23-2014, 06:48 AM

sirkay

sirkay is offline

sirkay uses Windows 7 64bit

Windows 7 64bit sirkay uses Office 2010 32bit

sirkay uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Feb 2014

Posts: 3

sirkay is on a distinguished road

Default

Quote:

Originally Posted by Scoth

View Post

It should work, is there any merged rows within the range?

There are no merged rows. In fact, I tried it for different ranges. It worked up to B2:B8000 but above this range say B2:B10000, it displayed "#Name" error

Last edited by sirkay; 02-23-2014 at 06:49 AM. Reason: It not I

Reply With Quote