|
|
| Group Total |
| Any body pls help......
Sheet1
Date/Week/Month/Category/Amount spend
1/1/Jan/Food/100
1/1/Jan/Travell/50
1/1/Jan/Fuel/200
2/2/Jan/......
2/2/Jan/......
Sheet2
Column-A/Column-B
Week/Total spend... on 20-Nov-09 |
| |
|
| How to round up to the nearest five |
| How can I make a 34 to a 35 etc etc.
How can i round up any number to the nearest five or ten?
E.G a 39 to a 40, a 6 to a 10 and a 1132 to a 1135.
thanks. on 20-Nov-09 |
| |
|
| Formula to extract number values only |
| Hi,
I cannot seem to remember how to use a formula to extract numbers only. For
example, I would like to take a create a formula to pull only "3.5" for a
cell that containts "Sum: 3.5"... on 20-Nov-09 |
| |
|
| Link 'Excel Object in Word' to Excel |
| I have a Word document which contains several embedded Excel objects which is
sent to 600 clients. The clients complete the data collection in the word
document and send back. We have a Excel works... on 20-Nov-09 |
| |
|
| Median of column I if column A numbers match |
| I am using the 2007 version of Excel. I have a worksheet with 13,000 lines of
data. Column A is titled ITEM and column I is titled PRICE. I need to find
the Median number of column I when the numb... on 20-Nov-09 |
| |
|
| Distribute an add-in using a URL |
| Hi! I am trying to get an .xla file to load up in the Add-ins from a URL. I
receive the following message when I try to add the URL link.."You cannot use
an Internet address here. Enter a path that p... on 20-Nov-09 |
| |
|
| pasting content copied from nonadajacent cells |
| I am trying to copy text from nonadjacent cells in a row in one spreadsheet
using Control/Select/Copy, and paste the text into adjacent cells in a row in
another spreadsheet. When I paste the content... on 20-Nov-09 |
| |
|
|
|