+ Reply to Thread
Results 1 to 3 of 3

Grouping similar text

  1. #1
    Registered User
    Join Date
    08-11-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    2

    Grouping similar text

    Hi,
    I'm have a simple spreadsheet, with a list of application names. Tha applicaiton names have multiple versions and I need to count how many applications as opposed to how many verisons.
    A quick example...
    Office 2010
    Office 2007
    Office 2003
    Application1 version1.4
    Application 1 version 5
    Applicaiton 1 version three
    Application2 v4
    Applicaiton2 v6
    Applicaiton2 version5

    so whilst there is 9 rows there are 3 applications and I'm trying to count the no of applicaitons. I can't split the text as the way the application and version is presetned isn't always the same.
    Any ideas how to group similar rows rather than exact?

    oh and I'm not exactly a wizz on excel so I will get lost with complex scripts.

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Grouping similar text

    I would probably do something like countif with the application name, for example:
    =COUNTIF(A1:A9,"*office*")

    it is case sensitive but it will not pick up spelling mistakes (or additional spaces like in your example), so you would need:
    =COUNTIF(A1:A9,"*Application1*")+COUNTIF(A1:A9,"*Application 1*")+COUNTIF(A1:A9,"*Applicaiton 1*")

    Edit: Sorry just realised I misunderstood the question, unless you had another list of possible applications to choose from, I don't have a way of counting the "unique but not that unique" entries in a list of data...

  3. #3
    Registered User
    Join Date
    08-11-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    2

    Re: Grouping similar text

    thanks anyway ragulduy

    I should have added my list has over 2000 rows.

+ 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. Grouping similar numbers in a row
    By Fugly in forum Excel General
    Replies: 7
    Last Post: 07-12-2012, 04:07 PM
  2. Grouping Similar Records
    By maw230 in forum Excel General
    Replies: 5
    Last Post: 10-21-2010, 03:26 PM
  3. Grouping Similar Terms
    By james598 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2010, 06:56 PM
  4. Grouping Similar items
    By crosswire123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-31-2006, 04:02 PM
  5. Grouping similar cell together
    By Timeferret in forum Excel General
    Replies: 0
    Last Post: 01-30-2005, 11:37 AM

Tags for this Thread

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