Forum Discussion
How to filter by multiple and values
Hello there, I've been racking my brain for the last day or so to try and come up with a solution to no avail. Basically an overview of what I am trying to achieve: Object 1 has qualities...
It's ridicoulous how that's easy with the googlesheet program instead of the client excel on a desktop... (using the =SPLIT function you can split the cell "1, 2, 4" in some columns, then you check how many corrispondences are in the each line and pick up the best.
With no =SPLIT function (as far as I know), you have to work with the "Split datas in columns" feature, but that's manual and not automatic (you have to do it whenever you need a new row with new Objects). Once you have the numbers of the qualities splitted in columns on the row of the Object, it's a match point!