Tagged Questions
0
votes
1answer
25 views
How to check if a date is in the future
I want to make a spreadsheet reporting daily and weekly goals for a certain quantity and their achievement, one reporting sheet per calendar week. Imagine that I open it on Wednesday, then I want to ...
0
votes
1answer
243 views
LibreOffice/Excel: SUM an adjacent cell if the value in the conditional cell is equal to N (SUMIF(?))
Disclaimer: I have no idea what I'm doing.
In LibreOffice Calc (3.6.2.2), I'm trying to SUM all of the values in G:x (where range is G2:G529), where B:x is equal to a given number N.
The data set ...
0
votes
1answer
109 views
Libreoffice Calc SUM returns ###
In Libreoffice Calc, sometimes the SUM function returns ### in the cell when referencing other sums. For example:
=SUM(x1+y1)
where
x1=sum(a1:d1)
y1=sum(a2:d2)
gives
###
in the output cell. ...
0
votes
1answer
153 views
Rows disappear when removing duplicates libreoffice
I pasted a lot of data in Column A.
Then I removed duplicates:
Data > Filter > Standard Filter > More Options > No Duplication
Now I'm stuck in row 2632, i.e. I can´t scroll up to rows ...
0
votes
1answer
69 views
Find a Certain Cell based on other Cells in Excel/Calc
I have a spreadsheet:
Beans B-kg Chips C-kg
1.4oz/12 0.47544 6.5oz/20 3.679
1.48oz/12 0.502608 7oz/12 2.3772
1.86oz/12 0.631656 8oz/20 4.528
and a ...
1
vote
1answer
58 views
Convert Text into a Formula in Calc
I have a bunch of cells in a spreadsheet like the following:
1.48oz/12
I am trying to replace the oz/ with * and then calculate it.
So far I have:
=REPLACE(G4,FIND("oz/",G4),3,"*")
which yields:
...
0
votes
1answer
626 views
How flexible is the 'indirect' function?
My curiosity pushes me to ask this question.
If I were to have a series of functions that referenced a different column in a worksheet but all ended on the same row of data is there a way to point ...
0
votes
1answer
534 views
Calc - How to combine rows from multiple sheets into 1 main sheet
I have several statements separating my various bank accounts in Calc, they all use the same columns and have a Date column which I sort them by.
I want to create a 'Overview' sheet which contains ...
3
votes
3answers
6k views
How to separate number by its decimal point in Excel/Calc?
I've got a number in a spreadsheet like so: 28.686279
When I open this sheet in either LibreOffice Calc or Microsoft Excel, is there a formula function that returns the "whole number", I.e. 28. Also, ...
