|
|
Formatting a Cell in Worksheets by
can u format a cell in a worksheet to accept text? for
example, input multiple comments that will be hidden from
view .... and then click on that cell to open...
|
October 18th, 2003 03:29 AM
by RagDyer
|
1 |
307 |
|
|
data validation & formulas by
Hello great folks who have saved me more than once:
I have a data validation list (drop down list) in one
cell, which offers a choice of 3 different...
|
June 16th, 2004 08:10 PM
by
|
8 |
420 |
|
|
How do I copy a combo box? by
When I copy a combo box, the new box is synchronized with
the first box. I.E, when a make a selection in the first
box the same selection is made in the new...
|
|
1 |
99 |
|
|
|
|
2 |
81 |
|
|
combining functions (VLOOKUP and SUM) by
I have an excel report that needs to be fed from an excel
database. The best function I found was vlookup. However,
vlookup only capture the result of one...
|
|
1 |
146 |
|
|
formula trouble by
I am having a problem with my spreadsheet.
K5 =SUM(C5:J5)
L5 =INT(K5)+HOUR(MOD(K5,1)/14.4)+(MINUTE(MOD
(K5,1)/14.4)/100)
example: E5=.30 F5=.30 I5=.15...
|
July 21st, 2004 01:37 AM
by
|
3 |
218 |
|
|
|
August 8th, 2004 02:52 AM
by JulieD
|
5 |
147 |
|
|
|
August 8th, 2004 09:46 PM
by
|
0 |
219 |
|
|
|
|
5 |
330 |
|
|
Workdays (inc Sat) formula by
I need a formula to tell me the number of workdays between two dates, the
problem being that Saturday I consider a workday.
The NETWORKDAYS function obviously...
( 1 2)
|
|
13 |
321 |
|
|
font size & length of data validation by
Excelperts!
Is there any way to increase the font size of the data in
a data validation list AND is there any way to lengthen
the box so you can see more of...
|
April 20th, 2004 08:56 PM
by
|
2 |
273 |
|
|
|
November 5th, 2003 07:50 PM
by
|
2 |
640 |
|
|
|
|
1 |
402 |
|
|
Count function by
I'm trying to count a column with some kind of criteria.
Count if cell contains EL or HC or MM etc.
Can it be done with the countif functions?
Appreciate any...
|
|
2 |
221 |
|
|
AARON by
can AND be put into an IF statment to make two arguments.
Like If C2=C3 AND B2=B3 ,B3=0,...
any suggestions
|
|
5 |
175 |
|
|
3D formulas to pull across worksheets by
I have six workbooks with about 75 tabs each. I want to
return the same values from each of the different tabs,
consolidated on to one tab. Right now we are...
|
|
2 |
264 |
|
|
percentages by
how do you calculate the percentage increase when only
your base number is a negative value? And is there an
excel formula that will do this?
|
December 24th, 2003 05:38 PM
by
|
0 |
121 |
|
|
Lookup with multiple results by
Is there any way to use lookup formulas to have Excel
find ALL of the values associated with the lookup
parameter and somehow list them out? Here's an...
( 1 2)
|
January 26th, 2004 06:19 PM
by RagDyer
|
15 |
424 |
|
|
Data Validation Limits by
I used Data validation to custom zip code because I needed
to limit the numbers. Some numbers started with 00 and if
I used the number or text choice the...
|
|
2 |
317 |
|
|
|
September 29th, 2004 11:36 PM
by JMay
|
4 |
122 |