Forum Discussion
Filter function - replacing values
Hello
I need to filter an array based on a value that is written by user.
My problem is that i want to change the values of the results shown by the filter function. But not by going in the array ... i want to change them directly in the place where the filter function gets the results.
Is that possible?
3 Replies
You mention the "filter function" and wanting to change the results IN the results. Correct?
But you don't say whether by "filter function" you mean the FILTER function or the filter capability available from the menu. If what you mean is the former, the results of FILTER, given that it's a Spill function (AKA Dynamic Array function), any time you go in an enter text that interferes with the dimensions of the Spill, it obviates the result of the function. So, NO, you can't change those at that stage.
But if you meant the filter capacity, yes, you can change the results there.
- I was trying to use the function not the menu capability.
I have an array with microchiped fish. Few hundreds.
The microchip id is a 12 digit number. Using filter i can sort quickly by just 4 digits and find the right fish with kg evolution over time...and i wanted to add a new value to the empty weight cell for year 2023
That was my "need".
Could be used on phone or tablet.. one cell used for entering search value and max 5 cells for id and last 3 years weight evolution...I have an array with microchiped fish. Few hundreds.
The microchip id is a 12 digit number. Using filter i can sort quickly by just 4 digits and find the right fish with kg evolution over time...and i wanted to add a new value to the empty weight cell for year 2023So how about this as a work-around:
Since those 12 digit IDs don't change, break them into text strings with the "just 4 digits" that you need to use isolated from the rest, and use that 4-digit field as the basis for filtering using the menu capability, which will then make entering your new data easy.
(Keep the full 12 Digit ID as a field of its own for reporting purposes, or wherever else that might be needed; but give yourself the convenience of that 4 digit short-cut.)
P.S. You can convert numbers to text with the TEXT function. Here's a link that explains it.
