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

		Microsoft Office Forums > Microsoft Excel > Excel
How to obtain maximum value of an excel column with a large range?

FAQ

Mark Forums Read

Thread Tools

Display Modes

02-23-2014, 06:48 AM

sirkay

Windows 7 64bit How to obtain maximum value of an excel column with a large range?

Office 2010 32bit

Novice

Join Date: Feb 2014

Posts: 3

Quote:

Originally Posted by Scoth

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merge large Excel spreadsheet in Word	goharar	Word	0	02-05-2014 05:32 AM
Paste special an Excel range into Outlook as an Excel Worksheet	charlesh3	Excel Programming	3	02-04-2013 04:33 PM
Excel - move with tab through named range	mjlaw	Excel	4	03-26-2012 10:40 AM
How to obtain the column “C” from column “A” and “B”?	Jamal NUMAN	Excel	2	02-26-2012 01:28 PM
load list box from range in excel	Joe Patrick	Word VBA	8	06-07-2011 09:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:26 PM.