Thread: Count number of occurences in a list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Count number of occurences in a list
It's not clear what you want to do and your link asks for login credentials.

--
Biff
Microsoft Excel MVP


"Lucas Reece" wrote in message
...
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.


Reply With QuoteReply With Quote