Forum Discussion
Solved
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...
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!
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)
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!