Lumping text data into numerical values on a secondary spreadsheet - help?

**carolannb** · 08-01-2012, 10:46 AM

Okay, so this is my first time to this forum and thank goodness it exists!

I am attempting to automate text values into another spreadsheet and convert that data into numerical values.

For example:

Say I have 4 columns and 200 rows. For kicks and giggles' sake, I am recording various apple consumer data for a major apple tree farm:
Macintosh, Washington Red, Yellow Delicious and Granny Smith

Now, of those apples, I want to evaluate who's giving props for each one. So I am going to record negative sentiments, neutral sentiments and positive sentiments.

I will also record values for how many of each were sold, among other subject matter.

By month's end, I am going to have to filter through a LOT of data #s to transfer to another spreadsheet.

So here's my question: How do I automatically convert this text data (for instance, "negative sentiments") for the particular apple brand to load onto another sheet without manual filtering/sorting? I would want the term "Negative" to equal "1"; and for every "1" term that appears on one spreadsheet can be transferred and tabulated on another? Make sense? Any help is greatly appreciated!

**ChemistB** · 08-01-2012, 04:28 PM

Okay, you have 4 columns. I assume those are for the 4 apple types. Then 200 rows. That is for each consumer? So then in each cell you would record negative, Positive or neutral (or leave blank if not applicable?)? Where would you fit in the values for how many were sold?. A sample spreadsheet would help (go advanced>manage attachments)