This is a discussion on Array Formula to Remove Duplicates from List within the Excel Questions forums, part of the Question Forums category; I'm looking for help with an array formula that will condense a long list like this: a a a b ...
I'm looking for help with an array formula that will condense a long list like this:
Last edited by jeffreybrown; Apr 10th, 2010 at 11:00 AM.
Welcome to the board!
I agree, advanced filter is a great way to go. You might also have a look at this thread data comparison which has code to take in any number of lists from one or more columns, sheets or books, and spit out a single list of unique values. I have the macro from post #5 in my personal book and find it handy.
You guys are awesome! Thanks so much--it works just the way I hoped. I'm still trying to get my head around the match function portion, which is the meat of the argument, but at least I can move forward in the meantime!
I am trying to do a similar thing Except my issue is, the function only works for numerical format or letter is fine. But if it is a text number format like "001", it wont work. Can anyone help here?
My function is this($D$11 is referencing the range of data I am filtering;F$18:F18 is the first data I found in that range):
Maybe I'm a little late to the party, but I ran across a really nice solution that uses a couple formulas to create a column that contains only the unique values from another column. It does require the use of a helper column, but you can always hide that. So far, I have tested this solution and it continues to update the values in my "duplicates" list.
Remove Duplicates or Create a List of Unique Records using Excel Formula