Please help

[ThrottleWorks]

I have one table with two columns. Column A has “Product” details such as mobile, battery, charger, etc.


Column B has status as “Available” & “Not Available”


I want to populate a second table on the base of 1st table.

The second table will have name of the product types marked as available.


For example table 1 will have following values,


cell a1 “mobile” cell b1 “available”

cell a2 “charger” cell b2 “non-available”

cell a3 “battery” cell b3 “available”


The table 2 should be like this,

Cell a1 = mobile

Cell a2 = battery


As cell a2 “charge” is non-available this will not be populated in the table 2.


List of all the available products should be populated serially in the 2nd table, is it possible ?


I cannot use VBA for this, I tried taking concatenate, vlookup, if/or condition but could not get the result.

Can anyone please help me in this. Trying various combinations from yesterday but could not get the results.

 

[srinidhi]

The easiest way is create a pivot table on u r data & filter on Available, this will display all the product who's corresponding value is Available.

 

[NARAYANK991]

Hi ,


Can you check out the following question and the worksheet posted there , since I think your question is similar.


http://chandoo.org/forums/topic/creating-a-dynamic-sub-table


Narayan

 

[ThrottleWorks]

Hi Srinidhi, thanks very much for the reply, I had totally forgoten that pivot could work. Once again thanks very much.

 

[ThrottleWorks]

Hi Narayan, I am working (understanding)as per the solution provided by you, thanks very much for the help.