+ Reply to Thread
Results 1 to 2 of 2

Auto Counter

  1. #1
    Registered User
    Join Date
    12-23-2013
    Location
    Ann Arbor, Michigan
    MS-Off Ver
    Excel 2007
    Posts
    4

    Auto Counter

    Hi guys,

    i need help in something like this. let's say i have the following data:

    Apple - from Column A1 ~ A25
    Orange - from Column A26~A34
    Pineapple - from Column A35~A47

    in Column B, i would like to have a 'function' or a counter that counts if Excel finds:
    1. Apple within A1~A47, it counts and adds '1' through '25' to B1 through B25;
    2. Orange within A1~A47, it adds '1' through '9' to B26 through B34,
    3. Pineapple within A1~A47, then add '1' through '13' to B35 through B47.

    thank you very much in your help in advance.

  2. #2
    Forum Contributor
    Join Date
    02-20-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    170

    Re: Auto Counter

    Hi ususim,

    In cell B1, enter this formula:

    =COUNTIF($A$1:A1,A1)

    Then just copy it down as far as your list goes.

+ 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. Row counter
    By UsmanBPD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2012, 08:19 AM
  2. Day counter is this possible
    By moley165 in forum Excel General
    Replies: 9
    Last Post: 04-11-2012, 12:54 PM
  3. Can you put a counter to 001 rather that 1?
    By v2jtb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2010, 03:13 PM
  4. Help with a counter
    By Nivag in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2007, 03:42 AM
  5. Counter
    By Polina in forum Excel General
    Replies: 2
    Last Post: 05-27-2005, 05:05 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