|
|
|
September 25th, 2003 03:25 AM
by Ron
|
2 |
411 |
|
|
Leading zero's in text join by
if it is formatted as text, it should not strip off the
leading 0.
-----Original Message-----
I have 4 colums a,b,c,d
I use A1&" "&B1&", "&C1 in colum d...
|
March 26th, 2004 09:35 PM
by
|
0 |
459 |
|
|
Adding a column of numbers by
I have a large worksheet and have entered numbers in a
column. Numbers range in value from 255 to 300. When I
perform the +sum(a1.a12) function my result is...
|
April 27th, 2004 05:36 PM
by David
|
3 |
375 |
|
|
Lookup returns N/A by
I have a worksheet with the following columns:
Client Number Client Name
These two columns are the result of a query that is
pulled from an accounting...
|
|
2 |
232 |
|
|
locking spreadsheets by
is it possible to lock my spreadsheet so that the formulas
can only be changed by me with a password or something, so
that if someone else is using my...
|
June 18th, 2004 06:11 PM
by
|
2 |
154 |
|
|
color format by
Why can't I color part of a cell?:
="The month is " & TEXT(TODAY(),"Mmmm")
|
|
1 |
79 |
|
|
nested functions by
I would like to nest a function that would first filter
the data in a column and then look for all of the "y" in
that filtered column. I thought this would...
|
|
3 |
230 |
|
|
excel locks on first cell I click by
the first cell i click locks and it acts like the starting
point of a range but i cant unclick from that cell. I have
to end task to get out help
|
|
1 |
108 |
|
|
Header by
Is there a way in the custom header menu to use only the
YYYY format for the date rather than the entire date.
|
|
1 |
114 |
|
|
Help by
Normally column C in my workeet is an eqaution eqault to
a minus B, where A is an equation and B is a value.
Occasionally, I have a user who wants to override...
|
|
3 |
117 |
|
|
rounding formula by
Is there a way to round a number to the nearest .5 -
ie .5, 1.0, 1.5, 2.0, 2.5, 3.0, 3.5 etc
TIA
|
February 5th, 2004 11:05 PM
by
|
3 |
157 |
|
|
Sumif cell has a boarder by
Hi,
I have a spreadsheet with a column that has cells with
totals and cells with just numerical data. Each cell that
I want to total has a boarder around it....
|
|
2 |
306 |
|
|
|
October 21st, 2003 09:55 PM
by Felipe
|
2 |
195 |
|
|
auto filter macro by
I want to use auto filter or some other device to hide
those rows whose first column has a zero in it. I would
like to come up with a macro that automatically...
|
|
4 |
430 |
|
|
Solver by
When i ask solver to create a sensitivity report, solver
only prints up half of the langrange multipliers.
Does anyone know how to get the others printed up.
I...
|
|
1 |
136 |
|
|
Formula needs more than 256 columns by
I want to calculate a MMULT formula and I need a table of
319x319 cells. Can I divide the table over 2 sheets or in
two parts on the same sheet and still use...
|
|
2 |
120 |
|
|
|
|
2 |
342 |
|
|
|
January 22nd, 2004 11:59 PM
by
|
0 |
519 |
|
|
formula needed by
Hello,
I have a spreadsheet that calculates our attendance, time
off, overtime etc. and I need to count the following:
If ST1 OR ST2 OR ST3 (this stands for...
|
January 28th, 2004 09:22 PM
by Biff
|
5 |
261 |
|
|
#VALUE by
I'm using the below formula and keep getting #VALUE as a
result when D20 is 0 or D20 is blank--what I'm trying to
achieve is if D20=0 OR D20 is blank, the...
|
July 26th, 2004 02:12 PM
by
|
2 |
108 |