Thread: How to obtain maximum value of an excel column with a large range?
View Single Post
 
Old 02-23-2014, 05:30 AM
sirkay sirkay is offline Windows 7 64bit Office 2010 32bit
Novice
  
Join Date: Feb 2014
Posts: 3
sirkay is on a distinguished road
Default 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.
Reply With Quote