6168 Shares

Topic: **How to write a text formula in excel****Question:**
I got some survey data.
In a column about 60 rows deep, I have various sentences that were multiple choice options.
Can Excel count how many times these sentences occur?

May 25, 2019 / By Devon

Excel can count the text if it is exactly as written in the formula: This is a simple example: =COUNTIF(A1:A6,"one") This will count how many times a cell in column A is occupied only by the word "one." If you are searching for sentences then the entire sentence would be required between the quotes in the formula. A1:A6 is just a reference to the range where the text in my example is found. Change that to suit your needs.

👍 126 | 👎 9

Did you like the answer? We found more questions related to the topic: **How to write a text formula in excel**

use the VLOOKUP() formula. basic syntax of it is: VLOOKUP(what you want to match, where to find the match, what column of data to retrieve from your match). for example on sheet X, some cell enter =VLOOKUP(A1, SheetY!A2:B55, 2, FALSE) this will look up what is in A1, try to find a match in your other sheet (SheetY, range A2 to B55) and if finds a match, returns the data from the 2nd column (B). (the "False" on the end instructs Excel to find an exact match)

If you want to pull the data from the second sheet based on the names, I have to assume a few things: Sheet 2 - column A contains names, Column B contains gift amounts Sheet 1 - column A contains names Your formula would look like this: In column B, Sheet 1 (first cell with a name next to it) =INDEX(Sheet2!B:B,MATCH(Sheet1!A1,Shee..... To briefly explain... INDEX - function tells excel that the data you want to pull from is located somewhere in Sheet2!B:B Sheet2 - name of the sheet from which you want to pull the data B:B - column the data you want to pull is in (could also be a specified range, like B2:B35 or whatever) MATCH - tells excel you're looking for something specific (you're looking for the data in Sheet1!A1) Sheet1!A1 - this is the data you're using to locate the data you want to pull in (using the name of the person to find the amount they donated) Sheet2!A:A - tells excel that the data you're looking for in Sheet1!A1 should also be found somewhere in Sheet2!A:A 0 - this means that excel will only return a value if it finds and EXACT match

I have a list of data in different cells, i.e."items" and would like the lower most to be a compilation of "total items" of the compiled from the individual "items" listed above. How do I do this??

👍 40 | 👎 0

Assume you want to group every 3 cells' values to 1 cell in a column In D1 you can put formula =IF(MOD( ROW(),3)=1, A1&"," &A2&"," &A3,"") copy it down to match the data in Column A, then you'll get the grouped value in column D at the starting row of each group of 3 Or if you just want to get the grouped data in Column D use the following in D1 then copy it down =INDIRECT( "A"&ROW( )*3-2)&","&INDIRECT( "A"&ROW( )*3-1)&","&INDIRECT( "A"&ROW( )*3) Please contact for more info.

If you save the data in a text file and open the text file with excel. Make sure you select "All Files" in the "Files of Type" tab after you enter the Open tab. You can use Fixed Width or Delimited to separate data. You can then sort through the columnated data to see if everything worked. It may take a few tries to get completely right. Be sure to save as an excel workbook or worksheet when you're finished.

If you have your own answer to the question how to write a text formula in excel, then you can write your own version, using the form below for an extended answer.