Notifications
Clear all
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
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