Automatic numbering in Excel with hierarchy...

How to do a row-wise sum in an array formula in Excel?...

Transform datatable from column-based to row-based...

Combine most recent 5 records into one cell in Excel...

Matching multiple number rows and check corresponding dates within 90 days...

Sum all cells for which corresponding cell is not a formula and doesn't return #VALUE AND date o...

How can I use countif to return only a count if sum is > 0 but only count it once...

excel No of hours in a shift...

How do transform a "matrix"-table to one line for each entry in excel...

How to fill fast for integer number calculation?...

Find Corresponding Value Based on Today's Date Falling Between Week-Ending Dates in Excel...

Date format issue when I try to find the first occurrence of names with associated dates...

Excel - How can we replace multiple characters or whole words in a cell using LAMBDA()...

Nested if statements in EXCEL dependent on first condition...

List only workdays in given dynamic month...

INDIRECT array to refer to a table column not working with array formulas...

Putting a concatenate inside of a count if...

Excel: how to search by two rows and one column...

Excel - Check existing digit count, if <10 then add prefix "100" to make it 10 digit...

Custom Excel formula for length restriction of substring within a string in a cell...

COUNTIFS across multiple columns with multiple criteria...

Occurrence by month using Excel Functions...

Strange behavior in Excel when counting Work Hours and Work Super Hours...

Need help fixing my excel formula so it doesn't show #VALUE! error in end result...

Can I guarantee the Image Formula Function is finished before printing the result?...

Excel filter data in date intervals excluding all 0 values...

Count cells with two conditions...

Formula to filter data based on prior 3 boolean "true" values...

I want the result of a function to return the value at the top of the column in an array instead of ...

Create a smaller dynamic list in Excel from data in a larger list using multiple criteria...