How do I extract a list of unique values from a list with duplicate values?

[robstark]

I have a running list in column B where new data/text can be entered.

I want column D to read column B and if a new entry is made in column B to add it to the list in column D. In other words list the same items in D as there are in B without the duplicate entries.

Column E needs to show the qty from column B and column F to show % of total

Hopefully my attachment helps to shed more light than this ramble did. I didn't add formulas (except in column f- I think a counta formula is the way to go, if not please let me know) in hopes I could get the easiest method to use when new data gets entered into column b.

Thanks in advance!
Rob

[AliGW]

You were asked to change the title of your thread, not start a new one. I have closed your original thread in favour of this one.

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

[robstark]

Sorry about that... this post has been a project of its own.

[Tony Valko]

Try this...

This array formula** entered in D2:

=IFERROR(INDEX(B$2:B$20,MATCH(0,IF(B$2:B$20<>"",COUNTIF(D$1:D1,B$2:B$20)),0)),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.

This formula entered in E2:

=IF(D2="","",COUNTIF(B:B,D2))

This formula entered in F2:

=IF(D2="","",E2/COUNTA(B$2:B$20))

Select E2:F2 and copy down as needed.