+ Reply to Thread
Results 1 to 5 of 5

Number of times same text is repeated

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    Moscow City
    MS-Off Ver
    Excel 2003
    Posts
    6

    Number of times same text is repeated

    It's really hard to explain.

    What I have now:
    A B
    1 Apple
    2 Apple
    3 Apple
    4 Lemon
    5 Lemon
    6 Peach
    7 Peach
    8 Peach
    9 Peach

    What I want to have:
    A B
    1 Apple 3
    2 Apple 3
    3 Apple 3
    4 Lemon 2
    5 Lemon 2
    6 Peach 4
    7 Peach 4
    8 Peach 4
    9 Peach 4

    Where B column returns number of instances text from respective A column cell appears in A column.

    Thanks in advance
    Last edited by fedfed; 08-09-2014 at 07:43 AM. Reason: Solved

  2. #2
    Registered User
    Join Date
    06-21-2013
    Location
    Wiltshire, UK
    MS-Off Ver
    Excel 2007 / 2010 / 2013
    Posts
    70

    Re: Number of times same text is repeated

    have a look at the Countif() function
    Isskint, i get satisfaction out of helping others

  3. #3
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Number of times same text is repeated

    =b1&" "&countif(b:b,b1)
    Click just below left if it helps, Booşathì

  4. #4
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Number of times same text is repeated

    Try this formula in C2 and drag it down..

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    then in D2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Copy down..
    after that you can copy the result column and then paste values in the B columns..

    Don't forget to click *
    Last edited by Vikas_Gautam; 08-09-2014 at 07:12 AM.

  5. #5
    Registered User
    Join Date
    06-12-2013
    Location
    Moscow City
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Number of times same text is repeated

    Huge thanks guys. It's almost unfair how simple that was. I can't believe I couldn't come up with it.

+ 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. [SOLVED] Highlighting text in a column- a different colour for the amount of times it is repeated
    By gavwalsh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2013, 04:44 AM
  2. Replies: 4
    Last Post: 04-17-2012, 03:24 PM
  3. Count Max Times a Number Continiously Repeated
    By Azam Ali in forum Excel General
    Replies: 4
    Last Post: 10-13-2011, 07:33 AM
  4. Replies: 3
    Last Post: 07-14-2005, 08:53 AM
  5. find out number repeated max. times in column.
    By vimivijay in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2005, 06: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