I definitely feel like saying it again - it works! Thank you. For sure, I can modify the if statement for what I’m working with. Thank you so much!
To clarify the first, yes to your example, I think so. I’m trying to optimize my scanning process, so, optimally, yes, I would only record all A numeric values in one go, and not come back to them again for the rest of the list. Good question; I never thought about this as a complication. So, I have shelves among shelves with a strict naming convention and containers with a different naming convention. I’m figuring out how to help me and my family be lazier and just capture the shelf name, then all the stuff there, then move on to the next place.
To clarify the second concern, yeah, I meant to make the comma denote two separate cells. I’m not sure how to make a table on lemmy through the Boost app.
Thanks for checking. I asked ChatGPT3.5 to make a solution with excel since I have limited access to it at work. CG came up with making my data a table with Power Query & using a Fill tool, but Fill>Down isn’t doing what CG is saying it’s supposed to do.
I hope I could do this at home though because I only have Onlyoffice & Libreoffice, & excel in the browser is so limited.
Wait, I need an animated diagram
I feel like every time I tell someone I know that I use linux mint, I’m coming across like I’m saying “I use Arch by the way” *eyebrow wiggle*
https://unnerv.jp/@UN_NERV