+ Reply to Thread
Results 1 to 2 of 2

Counting Number of Instances with Conditions

  1. #1
    Registered User
    Join Date
    09-08-2008
    Location
    canada
    Posts
    6

    Counting Number of Instances with Conditions

    I'm hoping you guys can help me out again, youve been great in the past..

    I have a spreadsheet with a list of hundreds of names (in one column), and their position (in another column). What I need to do, is count the number of instances each name appears in the spreadsheet, while at the same time, excluding 9 specific names that all have the same position. So for example,

    Name / Position
    A 1
    B 2
    C 3
    D 4
    A 1
    E 4
    F 5
    A 1
    B 2

    So lets say the position I want to exclude is position #4

    The outcome I would like is:

    Name / Number of Times Appeared
    A 3
    B 2
    C 1
    F 1

    Any help would be really appreciated...

    thx!

  2. #2
    Forum Contributor
    Join Date
    08-21-2006
    Location
    Ossett, West Yorkshire
    MS-Off Ver
    2003
    Posts
    150

    Smile

    Hi,
    Here is one way:

    =IF(B1=4,"",A1&COUNTIF($A$1:$A$9,A1))

    and drag down

    Hope this Helps

    Regards Howard

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Counting the Number of Months
    By incognito in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-12-2015, 05:40 PM
  2. Counting Number of Times a Numerical Response Occurs in Column
    By alex.salkever in forum Excel General
    Replies: 1
    Last Post: 09-18-2008, 02:03 AM
  3. help: counting number of permutations of 4 digits...
    By wann in forum Excel - New Users/Basics
    Replies: 21
    Last Post: 03-20-2008, 11:58 AM
  4. Counting instances of "N" within a date range
    By hottoku in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-21-2007, 07:17 PM
  5. Custom Number Formats and Conditions
    By cpadude in forum Excel General
    Replies: 3
    Last Post: 04-16-2007, 01:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1