View Single Post
  #6   Report Post  
Leo Heuser
 
Posts: n/a
Default

Or
=LARGE(Rng,SUMPRODUCT(COUNTIF(Rng,$D$2:D2))+1)
not array entered, but entered "normally" with <Enter

LeoH