REDUCE allows you to iterate through your data, building your result ... More specifically, REDUCE is what Excel refers to as a LAMBDA helper function. This means it depends entirely on a calculation ...