How to list only unique entries

**mkmed** · 07-23-2008, 10:33 PM

Hello all,

I am currently using concatenate function to look at six cells and return the combined text used in each. On some occasions each of the six cells will have a different unique entry - on these times, everything is fine. On the occasions where the entries duplicate is where the problem occurs. How can I construct the formula to only list each unique entry.

If it makes any difference, the data in each of the 6 cells is arrived with data validation and list box.

Thanks for any help!!!

Mark

**shg** · 07-23-2008, 10:48 PM

What should the formula do if the six values are not unique?

**mkmed** · 07-23-2008, 11:00 PM

Here is an example
Worksheet 1, cell A3 =CONCATENATE('Plank table'!B2,'Plank table'!D2,'Plank table'!F2,'Plank table'!H2,'Plank table'!J2,'Plank table'!L2)

This returns each entry from the cells on the "plank table" worksheet. When B2 = Walnut (or whatever the specie that is input) and there are several other cells with an entry of "walnut" I only want walnut returned once and not for every time it occurs.

The use of the example - walnut is only that, an example and could be any wood species.

Thanks,
Mark

**shg** · 07-24-2008, 01:45 AM

Can you post a workbook?

**mkmed** · 07-24-2008, 08:15 AM

Here is the workbook. The cell in question is A3 on the "estimate recap" sheet. Thanks for any and all help!!!

Mark

**sinn3r** · 07-24-2008, 12:28 PM

Solution is attached, I believe there are other solutions using codes or INDEX/MATCH/COUNTIF formulas combined.

However, this solution is best suited for your case as I see it.

Hide column I.