View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fiona Fiona is offline
external usenet poster
 
Posts: 70
Default Excel formula to read contents

Hi
Does anyone know ho to write an excel formula that will count cells if they
contain part of the specified information.

ie, I want to count if they include '1234' which is in box A1, but the
fields I'm searching in may have 'AB1234', but I still want it to be able to
count them if they include the details in A1.

I hope that makes sense!!
Thank you