• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

List different entries

C

carics

Member
Hello,


I have been trying to list all the different text entries in Column A.

The goal is to then use the list for validation purposes in a form. I could do it with pivot table, but I would prefer not to.


Giving it a little bit of thought, I suppose I could use a function to COUNT all the different entries. If there are for example 5 different text entries in the whole list, then I could use some sort of RANK or TOP function where I could ask for position #1, #2, #3, #4 and #5 on the top of most repeated texts in Col A.


Do you know such functions?


Thanks in advance.
 
Hi carics,


If you use the search box in top right to look for "create unique list" you should find several other threads with similar questions/answers. Basically, your options are

a) Use PivotTable

b) Use AdvancedFilter

c) Use macro

d) Use formula.


I'd recommend starting here, as it covers options b-d

http://chandoo.org/forums/topic/how-to-create-unique-list-based-on-data-available-in-range-of-cells
 
Hi Luke M,


Thank you for the reply. I took a look at it but I couln't get my preferred solution to work (formula). Actually, the macro was hard for me to follow as well, so I think I will stick to the method I already knew and used -> Pivot table + button with macro to auto refresh.


BR,

carics
 
Hi


If you are looking for a dependent data validation, have a look at here:


http://www.excelfox.com/forum/f12/dependent-data-validation-using-only-formulas-111/


Kris
 
Hi, carics!

Maybe this helps?

http://chandoo.org/forums/topic/individual-values-in-the-list-under-data-validation#post-45107

Regards!
 
Hi, carics!

Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.

Regards!
 
You must log in or register to reply here.
Back
Top