View Single Post
  #7   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

Sorry to sound impatient but can anyone help with this please?

On 28 May, 18:41, Lucas Reece wrote:
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).
Seehttp://spreadsheets.google.com/ccc?key=rifcz2bO3G1DfgoUtdbx1PA

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.