Reduce function formula challenge: This is a challenge to filter residents by city and have the data stacked up horizontally. The Reduce function si powerful for generating 2D arrays in Excel
00:00 Introduction
01:05 Problem Description
02:42 MAKEARRAY Overview
04:04 SCAN Function overview - brief
05:55 REDUCE function overview
07:10 Why REDUCE works in this Instance
08:30 Actual Solution to the problem
Link to Challenge:
https://www.linkedin.com/posts/excelbi_excel-excelchallenge-powerquerychallenge-activity-7008641723807510528-hgLp?utm_source=share&utm_medium=member_desktop
Link to Workbook solution:
https://docs.google.com/spreadsheets/d/1VTKfq4_b-Nbya1PYgRcO_UyBysWY6g1e/edit?usp=share_link&ouid=115481529442131367093&rtpof=true&sd=true
