• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 997
  • Last Modified:

=UniqueValues() Excel Morefunc Addin

I've downloaded the Excel Morefunc Addin which contains a formula to create a list of unique values based on a list (assume column A).

In Cell B2, I have a formula that reads {=uniquevalues($A$2:$A$500,1)}, however this only shows the first value when you drag the formula down; thus not allowing you to create a list of unique values.  Any help would be amazing!

Thanks
0
Golfer219
Asked:
Golfer219
1 Solution
 
dlmilleCommented:
First, select a range to hold your unique values, then type your formula, and hit ctrl-shift-enter when done.  The results will go into that originally selected range.  That's how you create an array output.

See attached where I've done that.  The yellow area was the original area I selected, then I entered the =UniqueValues() function, then I hit CTRL-SHIFT-ENTER and presto - the unique values turned up in the yellow area.

Enjoy!

Dave
Unique-r1.xlsx
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now