Forum Discussion
Filter function - replacing values
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 2023
So 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.