View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default How to increment the k in LARGE(array,k)

Hi Howard,

Am Sat, 30 May 2015 05:30:05 -0700 (PDT) schrieb L. Howard:

I had hoped the clarification would pretty much steer away from the 1 to 20 k value increment.

Say:

Large value in row 25 is in column Header10

Large value in row 26 is in column Header10

We now need to find a different value for row 26 to prevent Header10 from repeating.


please have a look:
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "Large"
If that is not the expected solution please post again.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional