All Questions
48
questions
0
votes
2
answers
121
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
4
answers
9k
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
3
answers
7k
views
Sum only if any one of six cells have a value
I would like a cell (total) to sum 6 other cells only if one of those 6 cells have a value. If none of the six have a value i do not want anything to appear.