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 ...
=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!