Results 1 to 8 of 8

Repeated words: remove duplicates, display word along with the number of times repeated

Threaded View

  1. #1
    Registered User
    Join Date
    10-21-2019
    Location
    california, USA
    MS-Off Ver
    2007
    Posts
    16

    Post Repeated words: remove duplicates, display word along with the number of times repeated

    I'm combining text write ups from multiple cells into one.
    I'm hoping to be able to remove ANY/ALL words that repeat, but keep a count of the total number of times they repeat:

    IE
    A1=apple. pear. fork. knife.
    A2=Pear. fork. mouse
    A3=dog. cat. goat. pear

    A4=Apple. Pear(x3). Fork(x2). Knife. Mouse. Dog. Cat. Goat

    Is this possible?

    Note:
    -the words wont repeat within the same source cell
    -looking to combine capitalized and non-capitalized
    -would be even better if it could identify repeated statements (separated by periods) as well,
    IE
    A1=apple. pear. fork. knife. Clean pears
    A2=Pear. fork. mouse. paint the cat green
    A3=dog. cat. goat. pear. Clean Pears. paint the cat green

    A4=Apple. Pear(x3). Fork(x2). Knife. Clean Pears(x2). Mouse. Paint the cat green(x2). Dog. Cat. Goat
    Last edited by number9; 10-21-2019 at 08:59 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-18-2018, 06:38 AM
  2. Need help copying rows that contain duplicates based on how many times they are repeated
    By bethanywalters in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2015, 10:00 PM
  3. [SOLVED] Number of times same text is repeated
    By fedfed in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2014, 07:43 AM
  4. Replies: 4
    Last Post: 04-17-2012, 03:24 PM
  5. remove the repeated words/numbers in a cell
    By darkhorse4321 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2011, 02:17 AM
  6. Replies: 3
    Last Post: 07-14-2005, 08:53 AM
  7. 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

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