LinkBack URL
About LinkBacks
Here, try this:
=SUMPRODUCT(--(COUNTIF($C$1:$C$16,$C$1:$C$16)>=$E$1))/$E$1
Where in E1 you define how much times number can be repeated: from 1 to max
(nope, sorry, not working)
Here, try this:
=SUMPRODUCT(--(COUNTIF($C$1:$C$16,$C$1:$C$16)>=$E$1))/$E$1
Where in E1 you define how much times number can be repeated: from 1 to max
(nope, sorry, not working)
Last edited by zbor; 01-16-2010 at 03:38 PM.
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks