Wednesday, February 23, 2011


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

mandi125 said ...
I have  A, B, C, D, E, F, etc as column PROD ID on one column .These products also have regions and markets where the products will be sold to. So those are represented as REGION and MARKET columns. Then I added a unique ID for each unique PROD+REGION+MARKET. So my question is how do I hide those multiple rows with the same PROD ID and show only one instance of PROD ID. And can unhide those rows when I want to edit them. So basically show only one instance of a PROD_ID no matter if column REGION and MARKET are duplicated or unique.


1                        514             X                A
2                        514             Y                A
3                        246             W               B 
4                        246             W               C 
5                        246              Z               B
6                        756             W               C 
7                        756              Z               A 
8                        756              Z               B
9                        846              Z               C 
10                      857              X               D
11                      999              X               D
12                      999              Y               D

Well, I have a formula based solution that extracts the rows of the table only for unique values of Product_ID. mandi125 check it out and see if this will work for you