View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wanda[_2_] Wanda[_2_] is offline
external usenet poster
 
Posts: 2
Default auto count possible?

I add a couple hundred orders to a file every day. Sometimes there are
duplicate order numbers. (Don't ask, ugh)

Column A contains those orders - today's orders get added at the bottom of
the file after yesterday's orders. If today I enter a line for order number
112233 is there a way to have column B automatically tell me the number of
times 112233 appears in column A?