View Single Post
  #27  
Old July 19th, 2004, 12:43 PM
andyp161
external usenet poster
 
Posts: n/a
Default Excel IF/LARGE Function problem

I cannot seem to set this formula within the ISERROR function - could
someone please help me??

=CHOOSE(MIN(SUMPRODUCT((K$2:K$79=K2)/COUNTIF(K$2:K$79,K$2:K$79)),5),500,250,125,75,"")


Kind regards


---
Message posted from http://www.ExcelForum.com/