|
|
Sorting a list of numbers by
ME Cochran
I have a list of consecutive numbers in a column from say 1 to 500. Does
anyone know an easy way to take these numbers in a new column and sort them
to be...
|
|
4 |
214 |
|
|
Calculating the number of months by
Philangr8
I have a column for start date and end date. I would like a formular that
tells me how many months it is including the start month and end month.
ex. Start...
|
|
3 |
176 |
|
|
Macro-save to html by
puiuluipui
Hi, i have a macro that save excel file to html, and i need a macro to add a
script to html when saving.
Can this be done?
Thanks!
|
|
0 |
135 |
|
|
Macro problem by
puiuluipui
Hi, i have a macro that save an excel file, but i have another workbook in
the same folder. i need to replace that file.
I need the macro to ignore the...
|
|
4 |
171 |
|
|
Select Subset of Rows/Cols by
Joe Thompson
I was given an Excel Spreadsheet (v2003) and asked to let the user print
subsets of data.
Is there a way to print out a subset of columns and rows (like using...
|
|
1 |
232 |
|
|
|
May 19th, 2010 02:37 AM
by FSt1
|
1 |
201 |
|
|
|
May 19th, 2010 01:13 AM
by yakir
|
2 |
169 |
|
|
Rounding up by
M Thompson
Hi
Please-How do you round up to the nearest $1000.00?
Thanks!
--
OneFineDay
|
|
2 |
152 |
|
|
VLookup by
slhaye
When I type in the VLookup formula and hit enter, the cell will not display
the result - it displays the formula. Then, when I copy it to the cells
below,...
|
|
6 |
184 |
|
|
Headers in Excel by
Beancounter
This question was posted in 2006. Has the answer changed at all since then?
Q: In WORD you can type away on your document, and the header and footer
will...
|
|
1 |
173 |
|
|
Formula returned instead of result by
Reno
from downloaded file, in A1 have CS1234567 and want the numbers only, used
value(mid(a1,2,7)) and instead of 1234567, it returned formula
value(mid(a1,2,7))...
|
|
3 |
163 |
|
|
Difference of the averages of two ranges by
Tommy
Can someone explain mathematically why the difference of the sum of the
average of row two and three (Range D2:D3) as shown in cell E3 is different
than the...
|
May 18th, 2010 08:47 PM
by Reeza
|
1 |
174 |
|
|
|
|
1 |
185 |
|
|
Add-In Launch by
MimiS
Just installed 2007 version and am missing the extra menu item that used to
be there for Hyperion Essbase add-in. It was at the top similar to File,
Edit,...
|
May 18th, 2010 08:42 PM
by MimiS
|
0 |
149 |
|
|
Shortcut to Convert files to 2007 by
NWoodham
Is there a keyboard shortcut that will convert my files from 2003 to 2007.
Currently I am pulling up each individually and clicking Office, Convert,
Yes,...
|
|
1 |
152 |
|
|
|
|
3 |
234 |
|
|
|
|
2 |
157 |
|
|
Excel links by
Perplexed
I am generating a spreadsheet in excel 2007 and sending it to one of my subs.
They then take info from my sheet and from another sheet and link it to a
third...
|
|
1 |
175 |
|
|
Excel Forms by
Andy
I have several forms that I use on a regular basis at work and having just
got a windows mobile phone HTC Touch pro 2 was wondering is there a way I can...
|
May 18th, 2010 07:34 PM
by Andy
|
0 |
189 |
|
|
Hope this is easy by
RobertG
How do I combine an alpha character from one cell with a numeric value in
another cell and display the result in a 3rd cell like this:
Cell A1 = B
Cell B1 =...
|
|
3 |
105 |