+ Reply to Thread
Results 1 to 3 of 3

listing unique words below table

  1. #1
    Forum Contributor
    Join Date
    07-13-2015
    Location
    Poland
    MS-Off Ver
    MS Office 365
    Posts
    174

    listing unique words below table

    I'm trying to find solution for listing all colours have been typed in Table1 in succeeding rows at column A and sum of each occurrences at column B (starting 3 rows below Table1).

    It would be simple if this table was prepared once. I could list all colours in each row and at column B use the COUNTIF formula, but the main difficulty is that Table1 will be filled by another user and I cannot know what colours and how many lines he will add.
    This is also why I want to start listing colours 3 rows below Table1 and when user will add another line my list should move lower.

    I was trying to reach that by using formulas or pivot table, but I think it would by the most efficient using VBA (even if I just start learning it).listing_colours.png

    anybody can help?

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: listing unique words below table

    This is perfect example for use of CONSOLIDATE Excel feature

    ExcelFeature_CONSOLIDATE.JPG
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: listing unique words below table

    Try something like this small macro:

    Please Login or Register  to view this content.
    For example:

    Untitled.png
    Gary's Student

+ 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. Listing unique text cells
    By Chrisbrough88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2014, 03:34 PM
  2. Listing Unique values
    By miguelcristovao in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 07-21-2014, 09:05 AM
  3. [SOLVED] Listing unique values without Pivot Table.
    By bungslea in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2013, 12:19 AM
  4. Listing unique values and summing w/o a pivot table
    By Drew Goldberg in forum Excel General
    Replies: 24
    Last Post: 02-16-2013, 09:52 PM
  5. [SOLVED] Listing all unique text combinations from three columns in a table
    By shabalgoel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2012, 10:33 AM
  6. Listing Unique Values from a Column
    By Rabi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2008, 09:39 AM
  7. [SOLVED] Listing Unique Observations
    By Henrik in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2005, 08:06 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