Forum

Notifications
Clear all

Excel file attached kindly go through it

2 Posts
2 Users
0 Reactions
191 Views
(@shetkar911)
Posts: 2
Active Member
Topic starter
 

I want to arrange few cells in such a way that if I choose any cell, I want a list of items to populated from that I want to choose some into the next cell.

For example: if I choose a laptop a list of items need to populate like charger, speaker, mouse-related accessories from that I need to choose few required items into next cell

kindly go through the Excel File attached

Thanks

Regard: Ishwar Shetkar

 
Posted : 15/02/2021 9:49 am
(@sunnykow)
Posts: 1417
Noble Member
 

Consider using a pivot table and slicer.

Slicer to select the categories (eg computer) and pivot table will display the items (speaker, mouse etc)

You will need to rearrange your data into two columns, one for category and another for the items.

See example attached.

 
Posted : 15/02/2021 11:56 pm
Share: