Linked Questions

74
votes
3answers
101k views

OpenOffice: get distinct values from column

How do I get a list of all distinct values from a column of values? Basically, this question: How do I get the distinct/unique values in a column in Excel? but I need the answer for Open Office ...
32
votes
7answers
177k views

How to count number of distinct values in a range?

I've got a large table that is already organized using filters etc. I'd like to add a summary underneath certain columns that contain the number of distinct values in that column. There's no ...
5
votes
5answers
63k views

Count unique names in excel column range

I have an excel spread sheet that contains a list of server names in column B. The server names appear multiple times in this column. I would like to count the number of unique server names in a ...
2
votes
3answers
14k views

How do I sort out duplicates using a formula in excel? Listing the unique values in adjacent cells. Without using VBA?

Pretty often I want to pick unique values from a table and list them in another, mostly to make statistics or summaries. A child can do this manually, shouldn't be too hard a task for my computer to ...
0
votes
1answer
7k views

How to count the sum of distinct Excel values in a column?

After having searched Google & Co. for hours and trying various examples, I still could not figure out out how to solve what I thought would be trivial to calculate in Excel: Having a table with ...
0
votes
4answers
5k views

Remove duplicates after filtering

After using this formula =IF(ISERROR(MATCH(A2,B:B,0)),A2,"") in column C, it nicely filters out the blacklisted numbers. But I need advice for a step further: How do I remove duplicates?
1
vote
1answer
1k views

Delete Duplicate Rows?

I have a column in an Excel spreadsheet with several hundred entries, and some of these entries are duplicated. I would like to remove all duplicate entries from the column so that each entry ...
0
votes
1answer
1k views

Excel: get list of unique values from a table and place the values in one column using formulas

I have a table of values that span across a range of rows and columns. Example data: Green Leaf Green Fire Red Fire Water Blue Blue Red Water I would like a single column of ...
0
votes
2answers
421 views

Excel: Goto Column differences broken?

so I have a single column on a worksheet. it looks like this: a,a,a,b,b,b,c,c,c,c,d,d,d,d,e,e,e,e etc (yes its a column. this thing doesn't like returns..) now if you click on the column, and ...
0
votes
1answer
259 views

Extract distinct categories and subcategories dynamically from a table in Excel

I have the following table: FRUIT COLOR TOT Apple red 2 Apple red 14 Apple green 22 Grape black 1 Grape black 4 Grape black 4 I want to dynamically populate a summary sheet like ...