Sorting by Column for Unique Text Values and Etc

[santeria]

I thought I had a Formula, but not really.

With the Basic Section below, I want to filter for unique words, how many times they appear, and hopefully for Unique Phrases, and Phrases in Strings (i.e. Multiple Phrases separated by Commas ),

Book2
	A	B	C	D
1	MonitoringScore	FeedbackGiven	Representative/Time	QualityDefect
2	96%	N/A		GuidelineAdherence
3	N/A(HRCallback)	N/A	N
4	100%	N/A	N/A
5	N/A(HRCallback)	N/A	Tomeka12:20p.m.	incompletetransfer
6	N/A(HRCallback)	N/A	2:10p.m.	incompletetransfer
7	98%	N/A		TelephoneServiceSkills
8	100%	N/A
9	N/A	N/A	PatinHR10a.m.	incompletetransfer
Sheet1

Hopefully I can get pointed in the right direction.
I loaded up Morefunc addin, so that will hopefully help.
I am totally unclear as to how I can edit the Row Formulas for columns.
I thought I had an idea, but not a clue right now.

Ta

 

[santeria]

Mmmm,.... HALP

 

[Zack Barresse]

maybe i don't fully understand what you want to do, but how about an auto filter.

or if your looking for slightly more dynamic, data validation with countif's - that is if your looking to count number of occurances.

 

[santeria]

I'm trying to do something with a Formula.
Basically, each column has re-occuring Words, Phrases, lines of phrases.
And, in a row, say about 5 rows below the last, I am trying to get a Summary of the Rows for each Input.

As yet, I have no consistency in terminology, but the attempt is to get a kind of trend analysis of the data. If I can get terms and/or Phrases listed, then I can take the analysis from their, but it is extracting the number of word , phrase, and I guess sometimes number occurence, that is what I am aiming for.

Aladin did it beautifully for Rows across Multiple pages, but I am aiming for something basic with Columns.

Does that make it any clearer?

Sorry about the vagueness ....


Ta