|
|
formula by
abe
i have a cell on my spreadsheet that i want to have a
numerical value increase daily automatically starting from
the day that it is inputed. from example in a...
|
September 19th, 2003 12:45 AM
by CLR
|
3 |
111 |
|
|
Multiple Lookup Function Problems by
Chris Wilcox
I'm having a problem with a function in a worksheet that
pulls information from another worksheet based on 2
columns. The formula I'm using...
|
|
1 |
155 |
|
|
Autocorrection List Function???? by
Miguel Cazares
Hi!!
I just had been installed MS Excel 2000 and when i begin
to add information, each character i type, appear an Error
Message saying something like...
|
|
0 |
192 |
|
|
Excel for Windows 97 by
moc
I'm new to this, and I have no idea where to start. I was
given an assignment that I just really do not know what
I'm doing.
I need to list information on a...
|
|
6 |
150 |
|
|
formulas by
abe
i want it to automatically increase everyday without
inputing the dates everyday. then i mind as well change it
myself. i will not know when the last day is...
|
September 19th, 2003 12:05 AM
by James S
|
1 |
124 |
|
|
Invert by
Wayne Burritt
Hi--I have a column of numbers for A1:A40 that I simply need to invert. Any
suggestions? Wayne
|
September 18th, 2003 11:31 PM
by Anders S
|
3 |
157 |
|
|
Dropdown Menu to Select Worksheet by
Dick Stumbo
I have an excel template that has 20 worksheets. I want to
have a drop down menu that will show on any worksheet and
allow me to select any other workshhet....
|
|
4 |
183 |
|
|
search engine by
moc
I need to put a search engine on an Excel spreadsheet.
This spread will contain various names, up to 2000 and I
need an easy way to find these names, I need...
|
September 18th, 2003 11:13 PM
by Anders S
|
3 |
419 |
|
|
Heading Row by
Michele Hart
I want to flip my heading row so that the fields are
listed down the side instead of across the top. Is this
possible?
|
|
2 |
134 |
|
|
|
|
2 |
355 |
|
|
minimum value without zero by
steve
If I have 4 cells, and I want the minimum value greater
than zero of the 4 cells, how do I write this?
Example
A2=3
B2=8
C2=0
D2=9
I want the formula (in...
|
September 18th, 2003 10:33 PM
by steve
|
5 |
210 |
|
|
macro problem by
David Kuehl
I have created several marco's in Excel and they work
great when you map to the drive they are on and run them
normal. If you try to run them through Explorer...
|
|
2 |
137 |
|
|
nested if statement by
Todd
I have a nested IF statement that is complex and DRIVING
ME CRAZY!!! It comes from a QuatroPro Worksheet but I
can't figure out what I am doing wrong with it...
|
September 18th, 2003 10:25 PM
by
|
2 |
396 |
|
|
Incrementing Months by
rob
Anybody know how to make Excel increment by actual
calender months. The DateValue function has a problem.
I want to create a column of month, day,...
|
|
2 |
143 |
|
|
Last Cell by
scrabtree23
When I hit Cntrl. End the cursor goes many many cells and
columns into the sheet. There is very little actual data
in this sheet and I would like to reset...
|
September 18th, 2003 10:11 PM
by RagDyer
|
3 |
133 |
|
|
Deleting Blank rows by
Jarrod
Other than sorting, does anyone know how to delete all
blank rows from a report in excel. The reason we need this
is b/c we have a software aplication that...
|
|
4 |
615 |
|
|
Capitalize all words on input by
shaggles
Is there a way to control how text appears when entered
into a cell? I want to create an input mask that
capitalizes all words in an address field no matter...
|
September 18th, 2003 10:02 PM
by shaggles
|
2 |
170 |
|
|
Date Range by
Dave
If I have a column of Dates and I need to extract all of
them between a given date range (ie. between 2/3/03-
3/1/03) how can I do this?
|
September 18th, 2003 10:01 PM
by Dave
|
2 |
124 |
|
|
Calculate Year by
MS
I would like to calculate the year a person turns 70 1/2
years old. I have the birthdate and would like to have
some kind of formula that would give me the...
|
September 18th, 2003 09:50 PM
by
|
1 |
203 |
|
|
Text function number format codes by
Peter Callewaert
When formatting a cell using this format code :
+0,00%;-0,00%
it is displayed correctly (red for negative values, green
for 0 or positive values)
When using...
|
September 18th, 2003 09:20 PM
by Peter
|
3 |
364 |