Search code examples
COUNTIF function if day of week is Tuesday...


excelexcel-formulaconditional-formattingcountifarray-formulas

Read More
Error When Inserting Formula greater than 255 characters...


vbaexcelexcel-formulaarray-formulas

Read More
SUMIF based on array...


if-statementgoogle-sheetssumarray-formulas

Read More
Return values, based on value of an intersection of a row and column...


excelarray-formulas

Read More
Return multiple items from a table...


excelif-statementexcel-formulaarray-formulasstructured-references

Read More
Auto populate a date series based on given start and end dates...


google-sheetsarray-formulas

Read More
ARRAYFORMULA with SUM, IF and AND...


if-statementgoogle-sheetssumifsarray-formulas

Read More
How do I get a list of non-contiguous values from a row in Excel (ignoring blanks)?...


excel-formulaarray-formulasexcel-2011

Read More
Using arrayformula() like continue with nested if()...


google-sheetsarray-formulas

Read More
calculate standard deviation by month...


excelif-statementvariancearray-formulas

Read More
How to Filter Out Blank Cells using ARRAYFORMULA (Google Sheets)...


google-sheetsarray-formulas

Read More
How to apply a formula in each row using ArrayFormula (maybe?) in Google Spreadsheets...


google-sheetsarray-formulas

Read More
Google Sheets, one distinct cell to calculate multiple values for multiple cells...


google-sheetsformulaspreadsheetarray-formulas

Read More
excel vba value paste all formulas of type "=X()"...


excelarray-formulasvba

Read More
Google Sheets: Formula in an Array in a Formula...


google-sheetsarray-formulas

Read More
Conditional Maximum in Excel using Array Formulae - how to ignore Blank Rows...


excelarray-formulas

Read More
Sum row based on criteria across multiple columns...


excelexcel-formulaarray-formulas

Read More
INDEX/MATCH for closest value to a certain date...


exceldateexcel-formulaworksheet-functionarray-formulas

Read More
Approximate match within a sub-array...


arraysexcelarray-formulas

Read More
How to apply google spreadsheet arrayformula for picking out the earliest date in a mixed set of val...


google-sheetssumifsarray-formulas

Read More
Multiple same values in Column A, need to find the greater date in column B...


excelif-statementmaxexcel-2010array-formulas

Read More
How do I apply a formula to a range without applying said formula to every cell?...


regexstringgoogle-sheetsmatcharray-formulas

Read More
Search for a value in another sheet and copy row if match?...


google-sheetsarray-formulas

Read More
Google spreadsheet query execute for entire column...


google-sheetsspreadsheetarray-formulas

Read More
ArrayFormula not working as expected...


google-sheetsarray-formulas

Read More
Obtain group average for numerous groups that vary in size...


excelif-statementexcel-formulacountifarray-formulas

Read More
Array formulas: nested ifs and same row calculation...


excelexcel-formulaexcel-2010excel-2013array-formulas

Read More
AVERAGEIFS seems to consider only single value in range...


excelif-statementexcel-formulaaveragearray-formulas

Read More
How do I add a third criteria to this Excel formula?...


excelexcel-2010conditional-statementsworksheet-functionarray-formulas

Read More
Excel VBA Calculate Method not update Array Formulas; showing as #N/A...


excelarray-formulasvba

Read More
BackNext