Tagged Questions
2
votes
1answer
42 views
How do I copy the results of a calculation without copying the formula behind it? Open Office Calc
How do I copy and paste only the results of a calculation without copying the formula behind it? I'm learning to use Open Office Calc. I remember other spreadsheets that had a values function, or ...
0
votes
1answer
47 views
Excel Formula For Re-arranging Numbers
I have got a bit stuck with trying to make a formula in Excel, and last time I asked a question here I got great help, I have come back again. At the moment I have column A with sets of product id's. ...
1
vote
3answers
173 views
Create a hyperlink from URL and title in Excel
I'm trying to construct a hyperlink from a URL and a name in different cells.
a1 = http://www.example.com/
b1 = example
c1 = <a href="http://www.example.com/">example</a>
What I want ...
0
votes
4answers
1k views
Excel - Smooth a curve by calculating / interpolating source missing values
I have a table of values like this one :
18
18
18
46
46
46
46
46
57
57
57
57
57
57
69
69
69
69
69
69
64
64
64
64
64
64
56
56
56
48
48
48
44
or if you prefer :
18
0
0
46
0
0
0
0
57
0
0
0
0
0
69
0
0
...
1
vote
1answer
2k views
Excel cell references not updating when referenced cells are sorted
There are two tables, each with 75 entries. Each entry in the 2nd table calls an entry in the first table a parent. One of my 2nd table columns contains the "Parent Price", referencing the Price ...
