Microsoft Office Tutorials and References
In Depth Information
GET AN ARRAY OF UNIQUE VALUES FROM A LIST
Alternate Strategy: If you replace SUM in the original formula with SUMPRODUCT
and replace the multiplication sign * with a comma, you could enter the formula
This form would probably look a bit more intuitive to some users.
764 test 32
1 test 2
24 / 12
PI() displayed to 14 decimal points
Underlying value = 0.75
Summary: You can use SUM (or SUMPRODUCT ) to build a formula that returns
the sum of all the digits in a string of text.
GET AN ARRAY OF UNIQUE VALUES
FROM A LIST
Challenge: You want to extract all unique values from a column of text data
that may contain several instances of a particular value. A procedure like this is
useful when you need to populate a list box or combo box with unique values
for user selection.
Solution: Assume that your spreadsheet contains a list of names in the range
A2:A30 on Sheet1. Cell A1 contains the header Name.
You can manually solve this problem by selecting Data, Filter, Advanced Filter