Only sort filtered list within a value from another column (similar to the partition by function in ...

Excel to dynamically generate SQL script using formula...

Create unique list and sum up values per unique row (without defining the filter criteria multiple t...

Generate a random list based on a main list (consisting two columns)...

How to create an excel formula using LET and other dynamic array functions which gives an calculated...

Create a list based on multiple filter criteria without row limitation in COUNTIF formula...

Remove space between an id number...

Sum up values per unique filtered row (if GROUPBY function is not yet available)...

Want to refer to "current row and cell" from another worksheet...

How to assign a category based on a number range?...

Excel Latest Date Summary...

Find particular word in excel and fetch values...

get respective column value without using vba...

Conditional formatting formula based on value in other sheet...

Highlight cell if any value matches another column...

Create custom cell reference/array in formula without enclosing string parameters in quotation marks...

Lookup matching cell in a table and return the value of the first cell that's merged upwards to ...

Create Sequence in Excel with repeating numbers every nth time...

Using average, offset & match together...

First the nth value in a table with a specific condition in Excel...

How to make Excel "IF" formula calculate blank cells as "0"?...

Can I have an ordered list with both numbers and letters in it?...

Length of strings with Unicode in Excel...

REPT function in Excel...

In Excel how to find days from dates in a specific cell date minus date in same row column without s...

TEXTSPLIT combined with BYROW returns an unexpected result when using an array of strings as input...

An advanced formula for getting serial nos automatically in excel...

How to convert a table to a list with row & column header...

Calculate SUMPRODUCT with multiple column criteria and one row criteria...

Using a list (range) of column criteria (not single cells) in FILTER formula...