Hello Libre Office Community, I am a new user of Calc and before I get really invested in it I need to know if it’s possible to do something. I have a column that is for exercises that I’ve done in a certain book. I don’t do them sequentially, so one day I did exercises 15 and 62. and entered that on the 1st row in cell 1b. Then on another day I entered 23 and 91 in the second row in cell 2b.
Now what I really want is a way to view all exercises that I’ve ever done sequentially ie 15 23 62 91. If I only enter one value per cell it would be easy. Just sort by that column. But I enter multiple values in each cell. So is there a way to do this? Any advice would be greatly appreciated.