Where can I post questions on how do construct formulas in Onlyoffice/Libreoffice spreadsheets?
Short term: I'm trying to automate transcribing a list from:
A
123
234
B
456
567
789
C
345
Into an array/table
123, A
234, A
456, B
567, B
789, B
345, C
Long term answer I'm looking for: where's a lemmy community I can ask questions like this (like about using formulas in Librecalc/Onlyoffice suite/maybe VBA with them too) in the future?
Or, if not yet established on lemmy, recommended librecalc/Onlyoffice forums?
Thank you for your time.
You are viewing a single comment
I usually divide a cell's value by 1. A value that isn't numeric will throw an error. Combining that with ISERROR or IFERROR, you can do some pretty powerful stuff.
Yeah, there are plenty of ways of doing that, but I was assuming OP’s sheet had other types of cells and that the A’s and 123s were a minimal working example.
And you were correct! I take sample data too literally lol