|
|
|
|
6 |
527 |
|
|
Excel functions help...additional by
Sothear
I'd like to achive an excel functions of the following scenario:
Column F (value), Column J (Code) A,O,and P, Column M, Column N, Column P
- If Column J with...
|
|
1 |
416 |
|
|
Excel by
Tennisman
How can I change the column headings from A...B...C to
1...2...3
|
|
1 |
99 |
|
|
IF Statements by
Bill
Is there any way to join IF statements? I find the fact
that you can only use 7 IF statements very useless! I'm
trying to create a spreadsheet using an...
|
February 6th, 2004 06:46 PM
by Danita
|
8 |
496 |
|
|
Excell Formula help by
TBD
I have a group of columns that I would like to pull the lowest number in
each column to show up at the bottom if it is the only lowest number.
To explain it...
|
|
3 |
284 |
|
|
sorting by
Mindy
Hi, I'm trying to sort a spreadsheet by two columns and I followed the instructions exactly but nothing happened. can someone help me? Thanks, Mindy
|
|
4 |
107 |
|
|
"Contains" in conditional formatting by
Mark
Is there a way to set conditional formatting to respond when a cell contains the text "msg" somewhere in the body of text in that cell?
|
|
2 |
476 |
|
|
changing calculations in a cell by
Paula
I want to add a function that will automatically add 1 number at a time in a cell by calculating only that cell. Reason-I want my invoice # to increase by 1...
|
|
2 |
127 |
|
|
Formula help required please. by
Andy Brown
Hi Pat.
Please can someone help me please.
A consultant, probably. FWIW, here's a couple of tips/comments.
With eg: Start Time in A2 & End Time in B2,...
|
|
5 |
154 |
|
|
|
|
0 |
181 |
|
|
Lookup by
Mike
I have a spreadsheet similiar to the following;
A B C D
1 JAN FEB MAR
2 expense 10.00 15.00 8.00
In a...
|
February 6th, 2004 10:28 PM
by
|
1 |
96 |
|
|
|
|
2 |
343 |
|
|
|
|
2 |
73 |
|
|
non blanks by
alldreams
How could I get a formula to work for the last non blank
colum of a cell range?
Any help will be greatly appreciated..
|
|
1 |
93 |
|
|
Cells not updating automatically by
Tom
I have a couple of very large Excel files, each of which
has cells that refer to cells in the other worksheet. I
have been experiencing a problem with values...
|
|
3 |
259 |
|
|
unhide sheet macro by
Owen
I have some files with many hidden sheets. How do I
unhide ALL of the hidden sheets using the fewest steps?
I would think that I could select multiple sheets...
|
|
2 |
228 |
|
|
Counting cells between 2 values by
abxy
Basically, i'm trying to count the number of cells that have dates
between 1/1/04 and 1/8/04, but all the cells that are being counted are
in one colunm in...
( 1 2)
|
|
11 |
339 |
|
|
Keeping cells clear with no data input by
A.W.J. Ales
Mike,
Change the formula's in the cells that depend on that one (still) empty data
cell (lets assume that that cell is A1) from :
Your Formula to ...
|
|
2 |
240 |
|
|
Conditional Formatting based on Colors by
Bob Phillips
Select all the cells, use FormatConditional Formatting, change Condition 1
to Formula Is and a formula of (for instance) =$A1=17, and set the...
|
|
4 |
419 |
|
|
BUTTON LINKING AND GRABING INFO by
DARRELL
Here is what I have. I have a work book with one sheet in it called IQS_2.xls that I fill in information, and save as a different file name each time.I have...
|
February 7th, 2004 12:51 PM
by DARRELL
|
0 |
165 |