+ Reply to Thread
Results 1 to 4 of 4

Return Number of Unique Valued Based On Specific Text

  1. #1
    Registered User
    Join Date
    07-16-2014
    Location
    Kohler, WI
    MS-Off Ver
    2007
    Posts
    12

    Return Number of Unique Valued Based On Specific Text

    I am trying to create a formula that will return the number of unique items in column B, based on what column A says.
    Example:
    I have tab titled "June" and column A titled "PO Open" and Column B titled "PO #". I also have a tab titled "ChartData" that will be used for building a graph.
    I would like cell G3 on the ChartData tab to tell me how many unique items are in column B June tab when column A says 12-18Mo.
    I would like cell G4 on the ChartData tab to tell me how many unique items are in column B June tab when column A says 18+.

    I know I can do a PivotTable and then manually enter that number onto the Chart Data, but I was hoping there would be a way to create a formula so it would automatically pull in the count of unique POs.

    I have attached the file.

    Thank you for any suggestions in advance.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Return Number of Unique Valued Based On Specific Text

    Does this give you what you want? I put this in G3 on the ChartData tab. It is an array formula so it has to be entered by pressing CTRL+SHIFT+ENTER instead of just ENTER.
    Please Login or Register  to view this content.
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.

  3. #3
    Registered User
    Join Date
    07-16-2014
    Location
    Kohler, WI
    MS-Off Ver
    2007
    Posts
    12

    Re: Return Number of Unique Valued Based On Specific Text

    PERFECT!! Thanks for the assistance

  4. #4
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Return Number of Unique Valued Based On Specific Text

    Glad it worked for you. Thanks for the rep too.

+ 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. Repeat text count based on unique ID number
    By rn_ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-29-2015, 04:04 PM
  2. Trying to Return a Number in a Cell based on Text
    By jslavinsky in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-01-2014, 03:17 PM
  3. [SOLVED] Return Column Number when specific text is found
    By Simon.xlsx in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-29-2014, 12:20 PM
  4. [SOLVED] If specific text is found in cell, then return a number
    By csch123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2013, 05:07 PM
  5. [SOLVED] IF number/text in a cell begins with specific letter, then return desired word
    By BPSJACK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2013, 06:02 AM
  6. [SOLVED] search for specific text in a file and return a value to a cell based on the results
    By JJGF in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-03-2013, 07:00 PM
  7. Replies: 2
    Last Post: 04-20-2011, 08:50 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