View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lucas Reece Lucas Reece is offline
external usenet poster
 
Posts: 18
Default Count number of occurences in a list

Hi,

I have a spreadsheet where I'm trying to count the number of
occurences of a value against another value (hope that makes sense).
See http://spreadsheets.google.com/ccc?k...G1DfgoUtdbx1PA

So, for example in B14, I would like to match value B13 against the
list in B2 to B11 and return the number of occurences of that value
against A14.

Can anyone help please?

Many thanks.