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

Thread Tools

Display Modes

02-23-2014, 05:30 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

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

I have a worksheet that has a number of columns. I need to obtain the first 5 largest values in a particular column. I know I can use LARGE(range, k) to achieve it but it didn't work with large range say B2:B38500.

« Previous Thread | Next Thread »

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 05:51 AM.