Forum Discussion
Formula to pull unique SKUs based on the Brand choosen
Hi, Attached is a screenshot of examples of how i would like a formula written where I choose the brand and a formula is below that will automatically update with the SKUs from the master data on...
=IFERROR(INDEX($B$2:$B$25,SMALL(IF($A$2:$A$25=$G$1,ROW($A$2:$A$25)-1),ROW(A1))),"")You can try this formula in cell F4. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. Then fill the formula down as required.