software

Hay everyone!
I have one problem in Excel and I'll try to explain it. It is complex
table (with formulas, etc.) but I have problem with one column. In this
column are quot;Productsquot; - all kinds, but I have to make sort within
categories- category of quot;carbonatedquot; and quot;non-carbonatedquot; product. In
all this table it is no specification which product is quot;csdquot; or
quot;noncsdquot;. So, my problem is how can I make filter for categories
if there is no specification? This table I got it because they want
filter for quot;csdquot; and quot;noncsdquot;. I have tried on a new sheet to specify
those categories for each brand and flavour but I do not know how to
link (or something else) it with existing sheet that have all the
data.
Can you help me, please. Thnaks!--
feliks27
------------------------------------------------------------------------
feliks27's Profile: www.excelforum.com/member.php...oamp;userid=33770
View this thread: www.excelforum.com/showthread...hreadid=535434If you have another table with the carbonation information for each
product, you could use a VLookup formula to return the data in the
complex table. There's information here on VLookup:

www.contextures.com/xlFunctions02.html

feliks27 wrote:
gt; Hay everyone!
gt; I have one problem in Excel and I'll try to explain it. It is complex
gt; table (with formulas, etc.) but I have problem with one column. In this
gt; column are quot;Productsquot; - all kinds, but I have to make sort within
gt; categories- category of quot;carbonatedquot; and quot;non-carbonatedquot; product. In
gt; all this table it is no specification which product is quot;csdquot; or
gt; quot;noncsdquot;. So, my problem is how can I make filter for categories
gt; if there is no specification? This table I got it because they want
gt; filter for quot;csdquot; and quot;noncsdquot;. I have tried on a new sheet to specify
gt; those categories for each brand and flavour but I do not know how to
gt; link (or something else) it with existing sheet that have all the
gt; data.
gt; Can you help me, please. Thnaks!--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html