Excel fomula for “Table Summary”

I have a list of products in my excel sheet1 (A:A contains the product code, B:B contains the color of item)

On sheet2, I would like to have a summary table that list the product code if the color matches value of sheet1B. (A1:Red, A2:Blue, A3:Green,…)

I know that the easier way is to filter the text but i hope to have a fomula so that when product get entered in sheet1, sheet2 will be updated automatically. 

By: Melvin

Leave a Reply

Your email address will not be published. Required fields are marked *