Wednesday, February 23, 2011

yogi_ShowOnlyOneIncidentOfProductID


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com


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.


UNIQUE_ID   PROD_ID    REGION     MARKET

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