Results 1 to 7 of 7

Conditional Counters

Threaded View

  1. #1
    Registered User
    Join Date
    05-17-2010
    Location
    New York, USA
    MS-Off Ver
    Excel 2010
    Posts
    45

    Conditional Counters

    I need to count problems per each client.

    Input:
    Client Problem
    1001 Minor
    1001 Critical
    1002 Minor
    1002 Minor
    1005 Critical
    1005 Minor
    1005 Major
    1005 Major
    1006 Major
    1006 Major
    1008 Minor
    1008 Critical
    1008 Critical

    Output that I need:
    Client Min Maj Critical
    1001 1 0 1
    1002 2 0 0
    1005 1 2 1
    1006 0 2 0
    1008 1 0 2

    Thank you
    Last edited by vicstone; 09-18-2015 at 11:49 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counters to count up. How can I
    By Larbec in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2013, 02:58 PM
  2. Need to setup 3 different counters
    By vicstone in forum Excel General
    Replies: 4
    Last Post: 05-18-2010, 10:59 PM
  3. if statements and counters
    By lilkatielady in forum Excel General
    Replies: 2
    Last Post: 07-10-2009, 04:00 AM
  4. Counters
    By halem2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2006, 04:59 PM
  5. [SOLVED] INVOICE COUNTERS
    By omega25 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-16-2005, 06:25 PM
  6. INVOICE COUNTERS
    By omega25 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-16-2005, 06:25 PM
  7. Counters
    By Paul in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2005, 10:06 AM

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