Home |
Search |
Today's Posts |
#1
|
|||
|
|||
counting unique instances of text in a list
I have a list of names in excel. They change frequently. I want to read the list and count how many times each name appears. for example if I have: bob bob tom sally frank bob sally I want it to return: bob 3 tom 1 sally 2 frank 1 I do not care if "bob 3" is 2 columns one for name one for count, or if they comibne with a concatenate or something, as long as it return the name and count together somehow. I really need it to do this without a lot of manual intervention. I don't want to do an "advanced filter" because I'd have to redo the filter evertime I look for the info. It needs to be dynamic. Just so you'll know I am actually pulling the data from a web query on a second sheet in the book. I've kinda got it working now but have to do the "advanced filter" every time I update data, and for some reason the filter always doubles up the first name if it is in the list more than once. I also do not care how the data is given to me, this can be done with VB (which I suck at) or standard excel formulas. I really really do not care how it counts the names and return the answers for me, jsut so long as it does. It can be a button I click and have a vb script add up and return info in dialog box, or whaterver. Can anybody help? It seems like this would be a standard function in excel, but I certainly can't find it, or jsut aren't smart enough to figure out how to use the function if I have. -- WadeSansing ------------------------------------------------------------------------ WadeSansing's Profile: http://www.excelforum.com/member.php...o&userid=23940 View this thread: http://www.excelforum.com/showthread...hreadid=375717 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation list drop down text format too small | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Counting Numbers with Text | Excel Worksheet Functions |