Forum Discussion
tmehringer01
Jan 19, 2024Copper Contributor
Formula Help needed for Comparing Two Arrays in Excel 365
I'm having trouble finding the right formula in Excel 365 to compare a column in an dynamic Table array with a separate dynamic list and having the formula output a variable list of items from a diff...
- Jan 19, 2024
Harun24HR Works like a charm! There are some advanced functions in there that I'm going to need to dig into to understand. Looks like the formula even caught one output that I missed.
Looks like they need to pay you more! Thanks again for your help!
Harun24HR
Jan 19, 2024Bronze Contributor
tmehringer01 REDUCE() is right function. It has capability to iterate based on give list and store each calculated result to accumulator. Try-
=DROP(REDUCE("",D2:D4,LAMBDA(a,x,VSTACK(a,FILTER(A2:A21,B2:B21=x)))),1)
tmehringer01
Jan 19, 2024Copper Contributor
Harun24HR Works like a charm! There are some advanced functions in there that I'm going to need to dig into to understand. Looks like the formula even caught one output that I missed.
Looks like they need to pay you more! Thanks again for your help!