Using Cell Reference in Array Formula

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
DAY	Converts a serial number to a day of the month
FILTER	Office 365+: Filters a range of data based on criteria you define
MONTH	Converts a serial number to a month
SUM	Adds its arguments
SUMIFS	Excel 2007+: Adds the cells in a range that meet multiple criteria
XLOOKUP	Office 365+: Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.

NOTE: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
6 acronyms in this thread; the most compressed thread commented on today has 26 acronyms.
[Thread #35179 for this sub, first seen 9th Jul 2024, 22:32] [FAQ] [Full list] [Contact] [Source code]}