|
|
Formula Not Auto Calculating by
RY
I have a simple formula--which sums the numbers in a
list. However, when I change a number in the list, the
total number is NOT changing. The formula is...
|
September 18th, 2003 08:41 PM
by Danny
|
1 |
138 |
|
|
Array Countif formula driving me NUTS! by
dprimm
I have been researching and trying to figure out how to get a
spreadsheet do some counting for me. I am on active duty with my
National Guard unit on a...
( 1 2)
|
September 18th, 2003 08:42 PM
by dprimm
|
13 |
1,111 |
|
|
|
|
4 |
117 |
|
|
sending text by
Arthur
Pulling a value into a cell is easy.
But can you go the other way, ie, can you send text to
another cell and then have that cell be a value not a
formula? Or...
|
|
3 |
146 |
|
|
Multiple splits/freezes per worksheet by
Dan Mackman
I need to freeze several rows at the top of my spreadsheet
and several at the bottom so that both the top and bottom
remain in view whilst a user scrolls...
|
September 18th, 2003 09:01 PM
by RagDyer
|
2 |
147 |
|
|
remove duplicate entries by
Jeff Schnakenberg
I'm trying to create a list of models from a column that has multiple models
with duplicate entries.
example:
column a
model b
model c
model b
model a
model a
|
|
1 |
512 |
|
|
eliminate duplicates in a column by
Kdorn
I have a large qty of numbers within a column with many
duplicates (2300+ rows). What function can I use to find
and eliminate all duplicate numbers?
|
|
1 |
281 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
|
|
2 |
355 |
|
|
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 |
|
|
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 |
420 |