View Single Post
  #4   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. Can you try the link again please. I'm sure I have set it for
everyone to view and edit with login?!??


On 28 May, 18:53, "T. Valko" wrote:
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).
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.- Hide quoted text -


- Show quoted text -