+ Reply to Thread
Results 1 to 6 of 6

Pulling unique list based on items in first column

  1. #1
    Registered User
    Join Date
    08-06-2014
    Location
    london
    MS-Off Ver
    10
    Posts
    5

    Pulling unique list based on items in first column

    Hi,

    I'm trying to pull summary information from a detailed sheet where I've added multiple fields for each value (e.g. the top table shown below). I've found a way to list out all the unique stages (with one item per list, but now need want to pull out the unique list of deliverables against each stage (e.g. table 2).

    I've seen forums on how to pull a unique list against certain criteria, but none of these look at a left hand column to pull a unique list to match against each left hand item.

    any thoughts?
    thanks
    Harry

    Presentation1.jpg

  2. #2
    Forum Contributor
    Join Date
    10-19-2012
    Location
    chennai
    MS-Off Ver
    Excel 2013
    Posts
    134

    Re: Pulling unique list based on items in first column

    Hi Use remove duplicates under data tab in the Ribbon

  3. #3
    Registered User
    Join Date
    08-06-2014
    Location
    london
    MS-Off Ver
    10
    Posts
    5

    Re: Pulling unique list based on items in first column

    Hi,

    I'm actually looking for this to be automatic as need to use this for a large number of toolsets so am looking for a formula to pull the right list through

  4. #4
    Registered User
    Join Date
    08-06-2014
    Location
    london
    MS-Off Ver
    10
    Posts
    5

    Re: Pulling unique list based on items in first column

    Does anyone know how this might be possible? I found this article but it doesn't really do what I need (close but it doesn't quite work)

    http://www.get-digital-help.com/2009...#comment-79705

    thanks
    Harry

  5. #5
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,249

    Re: Pulling unique list based on items in first column

    You mean like this one? Using array formula, you need to confirm press CTRL-SHIFT-ENTER button together, and copied down, and pls see the file attach
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    08-06-2014
    Location
    london
    MS-Off Ver
    10
    Posts
    5

    Re: Pulling unique list based on items in first column

    I think that's cracked it. You absolutely legend, thank you!

+ 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. Counting unique items on a list based on date in adjacent column
    By Mafoo17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2013, 04:24 PM
  2. [SOLVED] Show a unique list of items based on Cell value
    By gorgon777 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-10-2013, 12:18 PM
  3. Consolidate Unique List Items into an Adjacent Column
    By packetdog in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-09-2012, 11:29 AM
  4. Making a list of unique items in a column
    By portsample in forum Excel General
    Replies: 6
    Last Post: 06-30-2011, 07:42 PM
  5. Counting unique items in a list based on a condition
    By George Lynch in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-11-2005, 09:06 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