Solved: Duplicate reporting and formatting - Page 2

Neal_MF_Harper · 04-12-2019 10:47 AM

Hello All!

I have a huge list of merchandise with unique ID column [Merch ID], one of the fields is a “style” number [Style #], and like a UPC, it can be the same for several of our merchandise items, Merch ID representing the physical item, Style # representing they type of product, basically.

I’m trying to figure out a way to associate the merch items with the same [Style #], and formatting the [Merch ID] in a way team members will see at a glance that there are several instances of the same style number.

It would be great to have some sort of “related to” feature so when you look at the details of a merch item it shows the other items in that style group…

Steve

Yep, use FILTER(). If you have that Yes/No column I suggested earlier that indicates whether the row can even have related styles, you’d do well to use it as well to prevent the FILTER() from running for rows you know will have nothing related:

IFS(
  [Has related styles?],
  FILTER(...)
)

Try both with and without to see what the performance difference is.

View solution in original post