View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Greg Greg is offline
external usenet poster
 
Posts: 331
Default Counting a single value in a cell?

I want to count how often a single value (the dash symbol) occurs in a
single cell than rank it. Showing two examples, AUS-IAH/PTY-IAH/AUS is in
cell A1 and
AUS-ORD-LHR/WAW-LHR-ORD/AUS is cell A2. Cell A1 has 2 dashes and A2 has 4
dashes. Is there a way to do this?

Thank you.