IFERROR function breaking if a row has the same item in a different row...

$SPILL? Issue with Function to Match 2 Cells on a form to a Table and return a value from that table...

Excel Online - Office Script to filter table for non-blank rows...

How can I split data into multiple workbooks with file name based on column in Excel?...

Checkbox Grid into Single List Array...

how to use IF and COUNTIF in Excel 365 with multiple criteria with strings or text...

Parse LET variable names from another cell contents...

VBA function does not return dynamic array...

Textjoin with Filter Down a Column...

Is there an Excel formula that produces a dynamic spill array that displays the sorted and filtered ...

Copy Cells from Separate Range Without #SPILL...

Need Help to find an excel formula...

What formulas to use to check if 2 columns in Excel contain the same values not in same order?...

Split data in 1 column while retaining data in other columns...

Remove double values and sum the values...

Excel Attendance Sheet repeat friday twice...

Autofilter data in "Tab 2" from "Tab 1" using a VBA function...

`_xlfn`-prefix issue with current worksheet functions in MS 365?...

Excel: Dividing a column into a table with multiple criteria...

In a dataset where individuals have multiple rows of data per enrollment, how can I make a variable ...

Using office 365, how can I replace diacritics with 'normal' letters with an efficient formu...

Calculating dates based on changing priorities...

Excel, Load Sheet1 data to Sheet2, if Sheet1 rows increase Sheet2 rows should increase to show those...

I am looking to filter data based on multiple conditions across different column...

Sum cells with specific criteria of a column ignoring rows with other criteria in other column...

Find the match or matches with most same values in the same columns...

Excel Lookup Patrial Text and return the whole text...

Generate number by using Dynamic array (w/o VBA)...

Need an alternative to sumifs()/sum(filter())/sumproduct() to increase performance...

Excel DROP function unexpected behaviour...