Forum Discussion
Count of Unique Values in Column
Morning All, I'm stuck with a Problem that I'm not sure which formula will sort out, I got a Column with unique values in, now there are hundreds of these values and I don't know all of their nam...
Create a pivot table where the data source refers to the entire column where your data sits. That way, you can keep on adding items to your list without having to update a static range every time you do so. Just press the "Refresh" button after you added new items. They will be added automatically to the summary.
Have a look at the attached workbook and see if this makes sense to you. If not, let me know.
Riny_van_EekelenThank you very much! Let me give it a go and I will shout if there are any Issues. Have a Great Day.