I'm going through qualitative data and have the responses to open-ended questions recorded in an MS Excel sheet. I'd like to search for key words, then group all entries containing those key words. Something like "If this cell contains the word 'culture' then copy and paste it into column x (or worksheet x)"
2006-09-19 04:06:29 · 2 answers · asked by MHP 1 in Computers & Internet ➔ Software
go to INSERT>>>FUNCTION and select the appropriate function call from there
my suggestion would to use the IF OR ELSE etc functions to get you desired results!
2006-09-19 04:15:46 · answer #1 · answered by Jazz 4 · 0⤊ 0⤋
MMmm, it is kind of general question.
So let's try
Assume you have the values in column B, cell B1, type this function in C1 cell
=if( search("culture", B1)>0, B1, "")
and copy and paste this function into the cells below,
This is solution One
I do have more solutions, but I have to know if you are with me here or not, or can you do it, or need detailed info, so contact me for more...
Read my profile, I am the XLMan
2006-09-19 20:23:50 · answer #2 · answered by Anonymous · 0⤊ 0⤋