LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to count the number of occurences of a letter ? [email protected] Excel Discussion (Misc queries) 3 November 26th 08 02:30 PM
Lookup a value and count the number of associated occurences reddy Excel Discussion (Misc queries) 3 August 27th 08 11:37 PM
count number of occurences on a particular date [email protected] Excel Worksheet Functions 4 December 7th 06 09:11 PM
List Unique Occurences and Count PGiessler Excel Worksheet Functions 6 June 24th 05 03:49 PM
How to count number of occurences in an autofilter list sho Excel Worksheet Functions 1 May 16th 05 12:24 PM


All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"