andyp161 wrote...
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,"")

So what error or problem arises from entering

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

?

If you mean something different, post your formula and explain
*PRECISELY* what's not working.


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