+ Reply to Thread
Results 1 to 4 of 4

Numerical values increases as name increases

  1. #1
    Registered User
    Join Date
    10-02-2009
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    72

    Numerical values increases as name increases

    Lets say I input my name 'Mike' into a cell and the cell to the right I want to increase by 1 when the name Mike appears in a range of cells called range01

    1.So Right now Mike, 0<---the comma separates the cells
    2. I type Mike in 3 random cells in range01
    3. Now the Cells say Mike,3

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Numerical values increases as name increases

    =COUNTIF(range01,"Mike")

    or

    =SUMPRODUCT(--(range01="Mike"))
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    10-02-2009
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    72

    Re: Numerical values increases as name increases

    The Countif did the trick.

    Thanks

  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Numerical values increases as name increases

    No problem, glad I could help out.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Count consecutive increases
    By coldmejl in forum Excel General
    Replies: 5
    Last Post: 07-29-2014, 04:43 PM
  2. macro: The number next to name increases by one
    By dundukas in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-08-2013, 03:33 PM
  3. count consecutive increases
    By versus_app in forum Excel General
    Replies: 2
    Last Post: 05-23-2012, 04:52 AM
  4. Iteration continuously increases
    By jprice in forum Excel General
    Replies: 7
    Last Post: 01-11-2011, 10:25 AM
  5. Value of Cell increases with Date
    By jaymehall in forum Excel General
    Replies: 1
    Last Post: 09-19-2006, 01:59 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