New posts in Worksheet Function

Is there a way to express a complex Excel formula in terms of final (non-formula, value-only) cells?

sum of vlookup using array formula

How to make Excel 2010 auto-fill new row with formulas?

Is there an Excel function to create a hash value?

Excel Formula: What is the equivalent of =MATCH(), but for multiple columns?

Excel formula to convert boolean values into {0, 1}

Dynamically reference a Named Table Column (via cell content) in Excel

How do I create a data validation list WITHOUT using cells?

How do I find out what's linked to my Excel Worksheet?

How to combine values from multiple rows into a single row in Excel?