View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dannyboy213
 
Posts: n/a
Default Count items on the list


On column A, it is a list of different states (ie. CA, FL , NV and so
on). I don't know how many different states in the column because the
list is too long.

Is there a formula to know how many instances for each state on the
list.


--
dannyboy213
------------------------------------------------------------------------
dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032
View this thread: http://www.excelforum.com/showthread...hreadid=507788