To formulate a table based off a single row of Pivot data

**money n da sank** · 07-29-2008, 12:48 PM

I have a pivot table with multiple brands listed in alphabetical order. Based off that pivot table I want to create a new table ("new table" worksheet) that lists only those brands that I consider "buyable" first, followed by the remaining brands listed in the original pivot table. Because the data input range for the pivot table can change over time, simply referencing cells would cause an error in where those brands deemed "buyable" would appear in the "new table".

Basically, for visual purposes (and table/reference purposes later on) I want to list only those brands that are buyable first, followed by all the other brands in the pivot table.

I have tried {if(D6:J6='Brands to Buy'!C5:I5,'Pivot table'!D7,'Pivot table'!E7)} but it still lists those brands which I listed first as buyable. Surely there is a way to automate this so that a change inthe pivot data will not affect the order in which my buyable brands appear. I have attached a sample workbook so you all canget a clear image of what I want to do. Any help is greatly appreciated as I have been stuck on this for a week now.

Thanks in advance!

**steven1001** · 07-29-2008, 08:44 PM

The pivot table must be driven of some data. You could add a helper column to the data and use in the pivot table .. see attached.
Regards

**money n da sank** · 07-30-2008, 10:01 AM

Well the actual pivot table is so large that I chose not to create 1 in the sample. The first sheet in the sample is simply a mock table of the pivot table.

I don't want the new table to be a pivot table, I want it to filter out those buyable brands from the first pivot table and list them first then list all the non-buyable brands (to be listed for selling purposes) to the right.