Hello,

Thank you for your help. I gained a lot of data through a survey which has been transfered to excel.

This data is based on responses not multiple choices. I'm looking to sort data based on certain categories such as Costs. When users are writing down that they came "here" because of low cost, I want it to be considered Costs. Or if they say they came here because of financial aid, I want it to be categorized as Costs.

What I'm asking is, "Is there a way to filter results by having specific names and putting them into a specific category. I have tried to do find and replace but it will take me over a month to finish.

I have been messing around with pivot tables and it seems to work in a broad aspect of what I'm trying to do, but I will still need to do a find and replace.

Any suggestions would be greatly appreciated.

Thank you in advance.