View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default How to increment the k in LARGE(array,k)

Hmm, a bit of a moving target here.

Clarification:

The goal is to NOT return the same column header name consecutively.

If the LARGE happens to be column "Header10" for the value .234 and the next row LARGE is also in "Header10" (but the value may be 1.33) then increment the k value to Large(Array,2) which will make it return a different header name.

Howard