Search code examples
Root Mean Square (rms) function in VBA?...


excelvbaworksheet-function

Read More
Excel date/time difference...


excelworksheet-function

Read More
Worksheet Function with Index/Match...


excelindexingmatchworksheet-function

Read More
Refer to a cell in another worksheet by referencing the current worksheet's name?...


excelexcel-formulaworksheet-function

Read More
Sum Formula acts weird when added text to it...


excelsumworksheet-function

Read More
Excel functions to return first row or first column from a range? (for a better 2 way lookup in tabl...


excelworksheet-function

Read More
Return rightmost value in a row with conditions...


excelexcel-formulaexcel-2010worksheet-function

Read More
Excel 2013: How to copy selective columns form different workbook...


excelformulaworksheet-function

Read More
If cell H5 contains X return value from H5, else return value from cell ##...


excelexcel-formulaworksheet-function

Read More
Excel - logic for skipping rows in a formula...


excelworksheet-functionarray-formulas

Read More
Comparing values within a row...


excelif-statementexcel-formulaworksheet-functionvba

Read More
How to import data from one sheet to another...


excelworksheet-functionvlookup

Read More
Count subject to three conditions...


excelexcel-formulaworksheet-functioncountif

Read More
Calculate the time between two dates, excluding business hours and holidays...


exceldatetimeexcel-formulaworksheet-function

Read More
Combine two worksheets into a third...


excelexcel-formulavlookupworksheet-function

Read More
Removing opposites from Excel...


excelif-statementexcel-formulaexcel-2013worksheet-function

Read More
How to get average value (of column values) of a category (distributed in rows)?...


excelexcel-formulaaveragepivot-tableworksheet-function

Read More
Formula to generate a value according to a range...


excelif-statementexcel-formulalookupworksheet-function

Read More
Using MATCH() function with an unsorted list...


excelexcel-formulaworksheet-functionarray-formulasexcel-match

Read More
One-hot (dummy) encoding of categorical data in Excel...


excelexcel-formulaworksheet-function

Read More
Text encoding (converting to numeric) based on user-defined rules in Excel...


excelexcel-formulaworksheet-function

Read More
Checking if a number is limit (endpoint of range) in Excel?...


excelexcel-formulaworksheet-functionendpoint

Read More
How to remove parentheses and text inside from all rows in Excel...


excelexcel-formulaworksheet-function

Read More
How to combine data from 2 columns with values separated by a symbol?...


excelexcel-formulaworksheet-function

Read More
Transpose Data from every other Row to Columns...


excelworksheet-functiontransposevba

Read More
Nested formulas with error handling...


stringexcelif-statementexcel-formulaworksheet-function

Read More
How to add multiple numbers with the same name in the column?...


excelexcel-formulapivot-tableworksheet-functionsumifs

Read More
Look for value and subtract if duplicated...


excelexcel-formulalookupvlookupworksheet-function

Read More
How to merge two cells, add a space and a comma...


excelexcel-formulaconcatenationworksheet-function

Read More
LOOKUP function giving strange result...


excelindexingexcel-formulaexcel-2007worksheet-function

Read More
BackNext