|
|
Calculate business days between 2 dates by
Vic
I need to calculate how many business days between 2 dates.
G2 is report submission date
H2 is report reviewed date
K2 is the result - how many days it took to...
|
|
2 |
156 |
|
|
Allow sort of Protected Sheet by
TraciAnn via OfficeKB.com
I have a wb with several hidden sheets and hidden columns of the unhidden
sheets (When in UserView).
Although I turn on the "Sort" feature in the Protection...
|
|
2 |
137 |
|
|
traffic light formula by
Vikki
I am trying to create a traffic light formula in excel 2003. I want a cell B2
at the beginning of my spreadsheet to be green, if the date in cell K2 is a...
|
|
3 |
175 |
|
|
Combine rows in a coloumn by
Lost in Microbiology
I have a column of e-mail addresses and want to combine every value in the
column into one cell, separated by a semicolon (;) so I can send a mass
e-mail. I...
|
|
1 |
162 |
|
|
Deleting blank cells globally by
MrHanky
Hi, I have a 20x20 matrix of either non-zero values or "blanks" ("") that are
not constants--these cells have formulas.
I'd appreciate some assistance...
|
|
4 |
161 |
|
|
|
May 21st, 2009 03:20 PM
by Bob I
|
3 |
165 |
|
|
Excel Spreadsheet in Word by
Sherry
I have an Excel spreadsheet that has 119 rows and I would like to insert that
into a Word document. I've inserted it as an object, but when it comes in,
it...
|
May 21st, 2009 03:18 PM
by dlw
|
1 |
149 |
|
|
|
|
6 |
218 |
|
|
Data Validation Formulas by
retired bill
I have a main worksheet with a Data Validation Drop Down List. There is
another worksheet where I have the list/s of information, I have called
INFO1. ...
|
|
2 |
142 |
|
|
|
May 21st, 2009 02:37 PM
by Scott
|
4 |
141 |
|
|
|
May 21st, 2009 02:04 PM
by Bob I
|
2 |
157 |
|
|
Erase same content in all cells in Excel by
TaurArian[_3_]
S1L1Y1 wrote:
:: I am sending a sample of contents I have in the cells. I am trying
:: to erase everything but the URL address. How can I do it? I have in
::...
|
May 21st, 2009 02:02 PM
by Bob I
|
1 |
183 |
|
|
Printed Material Missing Fill Color by
Mr. C
When using a premade form (have used it in the past w/o any isses), the fill
cells will not print the fill color. I use a differant premade form, and the...
|
May 21st, 2009 01:56 PM
by Bob I
|
3 |
215 |
|
|
Row jumping formula? by
GD
Hi, reasonably simple one...I have some data in cells within one column but
separated by rows each time, so for example the figures are in BI5, BI8,
BI11,...
|
|
4 |
144 |
|
|
FORMULAS PROTECTION IN EXCEL WORKSHEET by
Ra
Please can you let me know if I can protect and hide several formulas in a
worksheet, yet allow the user to still input data and modify data once the...
|
|
6 |
155 |
|
|
MS Query will not start from Excel 2000 by
Ian
I have a problem when I select DataGet External DataNew Database Query,
Excel hangs with this message at the bottom of the Excel window
'Waiting for data...
|
May 21st, 2009 01:09 PM
by Ian
|
8 |
171 |
|
|
|
May 21st, 2009 12:49 PM
by NK
|
0 |
311 |
|
|
Increasing numbers. by
pawnraider
I'm trying to number cells but the way I would like to do it is in the
adjoining cell it will be the next number. Y'know like 1,2,3,4 and so on. I
have two...
|
|
3 |
136 |
|
|
window with update value by
pol[_2_]
Hai all,
ActiveCell.FormulaR1C1 = "=RC*REBATE"
When I am running the above macors , the excel will popup a new window
for save as the exisitng excel with...
|
|
2 |
138 |
|
|
batting average spreadsheet by
Trail Dog
when a player goes 8/8, how do i stop it from displaying a 1 ? i tried # ?/8,
but i still get a 1.
|
|
3 |
144 |