Once you understand SCAN in Excel, you’ll never build formulas the same way
www.makeuseof.com/understand-scan-in-excel/
SCAN function – Microsoft Support
support.microsoft.com/en-us/office/scan-function-d58dfd11-9969-4439-b2dc-e7062724de29
LAMBDA function – Microsoft Support
support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67