Jul 11 2020 12:59 PM
Hi
I will appreciate if somebody can help me to find the solution to this problem or even provide me a clue so I can go head do the rest myself.
I attached the file excel that I am working on.
I guess the best way to ask my question is with an example. Let's say I choose "Blue" "red" "yellow" "white" from column H (I already created a checkbox for this column and link each cell)
I would like to come up with a solution that each time I select different Colors from Column "I", it searches all the cells in column "inventory 1" and those cells that contain the selected colors (In this case any cells that contain "blue" "red" "yellow" "white") be extracted to column "New 1".
And I can do the same for "Inventory 2", "Inventory 3"..."Inventory 5" and results for each will be shown in Column "NEW 2" "NEW3" ..."NEW 5"
Jul 11 2020 02:21 PM
I think (could be wrong) that you're getting ahead of yourself by wanting to filter. Is it possible to do what you're asking? Yes.
But if you're really wanting to build a stock inventory, you'd be better off creating a better database at the heart of it all. There are templates for this. YouTube has a number of videos. Here's a link to one: https://www.youtube.com/watch?v=yap9EMwSK2I
I worked not too long ago with a family member who was building a business selling tableware. They'd gotten as far as selling on-line (through Shopify and Wayfair, among others), and as a result had SKUs and UPC codes. The valuable feature of those is that generally there will be a different SKU (same with UPCs) for Shirt, XL, Pink, from Shirt, XL, Blue....But there will also be a pattern such that Pants, XL, Pink may share a couple of digits with the SKU for Shirt, XL, Pink.....which leads me to suggesting that a good database design is more likely to have those kinds of characteristics as separate cells in the row, and one row for each distinctive product. Rather than "hard-coding" the full product description into a single cell (as you have them in your example), you are better off with several columns:
SKU UPC ItemType ItemSize ItemColor ....etc.
Filtering, Sorting, data manipulation in general, is greatly facilitated by doing that....
So that's the clue that I'd give you.
Jul 11 2020 02:36 PM
Jul 11 2020 02:44 PM
Well, so long as it doesn't contain confidential info, maybe you could post the actual file.
If you have the newest edition of Excel, there are functions like UNIQUE and FILTER and SORT that might come in handy. They're very new....and incredibly powerful. So there's another clue...if you'd like to continue trying to resolve it on your own.