Log In
Register
Home
Excel file attached kindly go through it
Ishwar Shetkar
New Member
Members
Forum Posts: 2
Member Since:
February 14, 2021
February 14, 2021
Offline1
February 14, 2021 - 11:49 pm
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
SunnyKow
Puchong, Malaysia
VIP
Members
Trusted Members
Trusted Members
Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016
Offline2
February 15, 2021 - 1:56 pm
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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Louis Muti
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Blair Gallagher
Brandi Taylor
Hafiz Ihsan Qadir
Gontran Bage
adolfo casanova
Annestine Johnpulle
Priscila Campbell
Jeff Mikles
Aaron Butler
Maurice Petterlin
Forum Stats:
Groups: 3
Forums: 24
Topics: 6369
Posts: 27852
Member Stats:
Guest Posters: 49
Members: 32359
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —