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 what is in column "A".
can anyone assist with this?
4 Replies
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.
=IFNA(IF(MATCH($A2,B$2:B$27,0),$A2,""),"")
This formula is in cell G2 and filled across range G2:J27. Does this return the intended result?
- Hi Oliver, Excellent, thank you very much it works perfectly!
