Need help on getting excel to count text entries

[sushiwarrior]

Hi, fairly inexperienced excel user here. I want to learn how to program excel to do this (or get it as close as possible):

1) Type in a text data in a predesignated entry box
2) Excel automatically inserts that text into a table
3) If that text is already in the table, then adds a counter next to it (or increases the counter by one)
4) Excels then clears the text data in the entry box

Basically, I want to tabulate the number of times a specific entry comes up, and it would be much faster if I can just type it in, press enter, and let excel do the rest. It would be ideal if I can also add a date to that entry, so the data table comes up to something like a date vs the entries table, and the intersection would be the number of times each entry comes up on that day.

Sorry if I made it confusing - I'm not very familiar with excel lingo (and if I was, I would've probably found a solution through searching this forum). And thanks for your help, guys.

PS: Where's the forum rules?? I see the subforum but none of them are in English.

[Pepe Le Mokko]

Hi
perhaps first read forum rules and adapt thread title accordingly?

[FDibbins]

Hi and welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[FDibbins]

Thanks for the title change

PS: Where's the forum rules?? I see the subforum but none of them are in English.

Click on the Forum Rules button on the light blue bar at the top(-ish) of the screen...between Calendar and Winner Board

I think you will need VBA for this, so I will move it to that forum for you

[watersev]

hi sushiwarrior, welcome to Excelforum

Please check attachment if that what you are after. Enter word in Entry box on sheet "Entry" and press Enter. Check sheet Data and Report.

[sushiwarrior]

Oh wow thanks! How did you do that?? Can you refer me to the relevant guides that can walk me through? And what is the purpose of the last sheet - "Report"?

[watersev]

I would suggest to look here: http://www.excelforum.com/excel-prog...materials.html

Report sheet gives quantity of words by dates as Data sheet holds a data table with records and dates only.

It's done with two small codes. One is for combobox on Entry sheet and one for the Report sheet.