Top 10 unique text

[niravrph]

Hello,


I have 700+ rows of survey responses with "free form" text such as the below example. I need to sort all of these to arrive at the top 10 or 15 responses.


Since there were extra spaces, punctuations and other problems scattered thruout the list I used delimiters to sort the words into individual columns. The problem is now that I have it a bit cleaner - I can't seem to auto-filter and arrive at a Top 10 per column. Excel won't let me (I get that "bummp!" error sound we all know and love). I need to do this to know which responses got the most votes.


Thank you for any help you can give me! Rock on.


Shirts, luggage tags, luggage, hats

Shirts, hats sweat shirts

jackets, hats, luggage, etc...

shirts - work appropriate

Gold shirts, Dress shirts, hats, coffee travel mugs, sales bags, fleece's, outerwear.

Golf shirts, hats, jackets, travel bags, luggage tags

Swetshirt or Jacket

hoodies, tshirts, yoga pants

dress shirts/ mugs/jackets


Thank you,

NIRAV

 

[Luke M]

I believe a PivotTable will help a lot here. But first, a side note:

Is there any difference in the different columns? If not, copy all the data into 1 column. If so, just make sure each column has a unique header


Once the data is prepped, select it all, create PivotTable. for the column you are interested in, place it into the row area AND into the data area. Data field should be set to Count by default, but double check. You can now sort in descending order to see what were the top responses.

 

[niravrph]

Luke,


I'm humbled by your sheer awesomeness. Thank you! Problem freakin' SOLVED, baby!


NIRAV

 

[Guest]

Coach Outlet On the net frequently are situated close to the world. They are the merchandise that Coach Sling Bags first be bought on its shops to coach outlets find out customers' reaction, nicely just before sending them to shops. The one thing that you simply cheap coach purses must not expect to check out at Coach Bags Outlet is hottest manner or model stock. These retailers retain inventory of overstock things only. These are generally the goods that happen to be returned to manufacturer for not being sold at its malls and departments demands to interchange this previous stock with new a single.


To achieve an excellent earnings, they should marketplace their products to assistance this type of commence in Coach Outlet On-line. The true headquarters utilizing the instructor outlet retail outlet on the web very small purses with San francisco. this could be the publicly traded company.The real shops promoting and advertising today's feeting buying cheap coach purses bags by which draw the real substantial worthy of of distributing continual merchandise faraway from these sort of retailers. This unquestionably is made available that their sustain attributes an incredible earnings margin. To support you have a floorboards liberty for that newest research.


Every single coach outlet desires a certain quantity of focus and upkeep, and new coach outlet cheap coach purses have to have a lot of function to produce them worthwhile. It will take lots of consistent get the job done to even create a financial gain from an Coach Outlet. Some chores can finally be outsourced, but even below you must remain on major with the full approach and can't just count on factors to operate by themselves.So, if you do not brain using Coach Outlet then the deal can be your most advantageous discount. These outlets also are trial centre of new launches far too.