Currently, I have an extremely large (thousands of rows) spreadsheet which contains the following (I'm leaving out other irrelevant columns):
Column C (Date)
Column D (Name of Product Sold)
Column F (Price)
Column N - the issue
What I want is to have Excel automatically (as soon as data is entered into column D) pull the unique product names in column D and list them alphabetically in column N. In column D, there are about 30 different product names total and they appear numerous times throughout the column.
I'm sure there's an easy way to do this, but I'm sure you guys are much faster to figure it out than I'd be on my own!
Thanks.
Bookmarks