All Questions
4
questions with no upvoted or accepted answers
1
vote
0
answers
246
views
Dynamic timeline spreadsheet with selective stickiness?
I'm trying to create my first spreadsheet ever, but there's one function that I'm finding very difficult to find guidance for from the internet, just like the title of this post felt a bit clumsy to ...
0
votes
1
answer
468
views
LibreOffice Calc: Exclude rows from INDEX() reference
Working on Sheet2, I can use the following formula to look up the "Sheet2.B1"th match in Sheet1, column B corresponding to Sheet1, column C:
{=INDEX($Sheet1.$B$1:$B$9,SMALL(IF($Sheet1.$C$1:$...
0
votes
1
answer
53
views
Spreadsheet: How can I merge every nth line with a previous line?
I have a spreadsheet where each cell contains multiple key value pairs. Every value is on a new line. The content of every cell is the following: cell content I need to somehow merge the every second ...
0
votes
0
answers
30
views
Get addresses for all duplicates in a spreadsheet
I am trying to analyze output of performance benchmark. My spreadseet consists of multiple Linux top outputs spawned every 0,5 s for about a minute. I need to identify keywords that will help me ...