What is the formula for comparing Column A, Rows 1-518 with column B, Rows 1-150 for matching words that are then outputted as a 3rd list(alphabetically ordered) in Column C?
Please help, I am a total beginner with Spreadsheet stuff, I have achieved a couple of things by getting the text to import, formatting lists correctly to insert into a column, creating csv files and batch adding commas to lists, most stuff with Writer and then simply learning how to get one list of text to import into the column B. These are very basic, VERY basic functions I know, but I am a complete beginner and they were foreign to me till I made them do what I needed. I am now stuck at the final thing I need, I am unsuccessfully being able to achieve the answer to this question by following tutorials or reading forums, I don’t think I understand dragging with the mouse and highlighting to apply formulas also so I am a total beginner and would appreciate the answer and directions for this question. Many Thanks. Kind Regards. Billy.