Forum Discussion
Distribution Reports
I have a master list of products in Column "A" and stores across the top in row 1. Some stores have less products listed in the column beneath and I'm trying to sort the columns so they line up with ...
Excel 365 with workaround for Excel nested array limitation
= LET(
isStocked?, DROP(REDUCE("", {1,2,3},
LAMBDA(acc,k, HSTACK(acc, COUNTIFS(INDEX(stocked,,k), product)))),,1),
IF(isStocked?, product, "")
)['product' highlighted in red, 'stocked' in blue]
Hi Peter, thanks for your assistance.