View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
KellTainer
 
Posts: n/a
Default Count() question


Assuming your numbers are from A1 to A10.

in B1, =COUNTIF($A$1:$A$10,A1)

Drag down till B10.


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=549290