Formula Forensics No. 34. Extract words from a cell, where they occur in a list of words.
Use Excel to extract matching words from a list of words from a cell containing a sentence into individual cells in the order they exist
Transpose a table of data using Excel Formulas
Today lets tackle a familiar data clean-up problem using Excel – Transposing data.
That is, we want to take all rows in our data & make them columns. Something like this:
Learn these 4 techniques to transpose data:
1. Using Paste Special > Transpose
2. Using INDEX formula & Helper cells
3. Using INDEX, ROWS & COLUMNS formulas
4. Using TRANSPOSE Formula
Automatic Rolling Months in Excel [Formulas]
Often when we are making spreadsheets for forecasting or planning we would like to keep the starting month dynamic so that rest of the months in the plan can automatically rolled. Don’t understand? See this example: This type of setup is quite useful as it lets us change the starting month very easily. We can […]
Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]
Here is a quick excel formula tip to start your week. Use ROWS() and COLUMNS() formulas next time you need sequential numbers. What does ROWS() excel formula do? ROWS excel formula takes a range as an argument and tells you how many rows are there in that range. For. eg. ROWS(A1:A10) gives 10. How can you […]