logo elektroda
logo elektroda
X
logo elektroda
Advanced Search
logo elektroda

Excel: Create Unique Name List from Column A without Duplicates - Dynamic Data Update

noam 19959 7
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
Reply | New topic
  • #1 11581894
    noam
    Level 9  
    Hello,
    In Excel, I have a file in which I have one column with repeating symbols written in it. How to make Excel make a list of symbols for me (without repetition), e.g. in the next column.

    Example:
    In column A I have a list of first names (they can be repeated). I would like Excel to provide me with a list of names from column A.

    Manual check misses the point, the more so because the data changes dynamically, something goes missing.

    Regards
  • ADVERTISEMENT
  • Helpful post
    #2 11582315
    marek003
    Level 40  
    If it is a one-time operation:
    in excel 2003 and below :
    Select a column with data.
    Data menu - Filter ... - Advanced filter.
    You select copy to another location.
    You leave the window with the condition blank.
    In the target box ("Copy to:") select the first cell where the list is to be pasted.
    check "Only unique records"
    and press approx.

    in excel 2007 and above :
    Copy the data column to the target column.
    On the ribbon, select the Data tab and hit "Remove duplicates".
    Click OK
    and that's it
  • ADVERTISEMENT
  • #3 11582367
    noam
    Level 9  
    Cool. Thank you very much.

    Is there any way to extract unique cells from multiple columns for one target column? And is it possible for the records in the result column to react dynamically depending on how the names of the original columns change?
    Attachments:
  • ADVERTISEMENT
  • #4 11582413
    marek003
    Level 40  
    Here we will need functions [now I mean count if (), if (), max () and max.k () all in one, of course] and at least one auxiliary column.


    edit:
    Now I have noticed "of many"

    Provide sample data - it will be easier to understand what you mean.
  • ADVERTISEMENT
  • #6 11583760
    marioodkrywca
    Level 13  
    Honestly, I don't quite get it. A vertical search comes to mind. also it will select only one data. unless you care about the number of appearances.
  • Helpful post
    #7 11584079
    marek003
    Level 40  
    Well ... you made the task a bit more difficult.
    There was something recently with employees across departments - creating a continuous list of employees. A colleague of Adam there proposed an interesting solution.

    Here, too, one would have to do a similar thing.
    First, make the same table as it is, but no doubles in the columns, and then arrange it in one list.

    edit:
    Although, as it turned out, I was working on the idea with references then, I must admit that in order to adapt it to this example, I had to think for a moment how I came up with it then :) I am amazed :)

    The entire "engine" is grouped. If you press a plus, it will expand.

    edit2:
    I changed the attachment because the earlier one allowed for doubles between the columns - now this error is no longer present
    Attachments:
  • #8 11587494
    noam
    Level 9  
    Good job. And the auxiliary formulas are impressive. Now I just need to figure out how it's done. Thanks for your help, really good job.
Reply | New topic
Report a violation of the law

Topic summary

In an Excel discussion, users sought methods to create a unique list of names from a column containing duplicates, with a focus on dynamic data updates. For Excel 2003 and earlier, the solution involved using the Advanced Filter feature to copy unique records to another location. In Excel 2007 and later, users can utilize the "Remove Duplicates" function from the Data tab. A follow-up inquiry addressed the extraction of unique values from multiple columns and the need for dynamic updates in the result column. Suggestions included using functions like COUNTIF, IF, and MAX, along with auxiliary columns to manage the complexity of the task. The conversation highlighted the importance of creating a consolidated list without duplicates and adapting solutions to changing data.
Summary generated by the language model.
ADVERTISEMENT