Function/Formula Help

[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]

Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional. Thanks!

No help to be offered, please, until the OP complies with this request.

[robstark]

This did explain my problem... I have no idea what to title the post because I'm not sure what to ask for.

Not trying to be a problem, but when you don't know what you don't know how do you expect someone to ask the question?

Would the word "assistance" be more appropriate than "help"?

[AliGW]

Try this: "How do I extract a list of unique values from a list with duplicate values?"

[robstark]

Perfect- thank you!

[AliGW]

You need to edit your opening post, go advanced and replace the original title, please.

[AliGW]

Duplicate thread closed. Go here, please: http://www.excelforum.com/showthread...21#post4553421