|
|
|
December 31st, 2003 12:59 AM
by dsds
|
10 |
282 |
|
|
formula error by
Mike
The following formula is looking for "CSR" in either Col.
D, E, or F.
=IF(D3="CSR","CSR",IF(E3="CSR","CSR",IF(F3="CSR","CSR","NO
MATCH")))
What it is trying...
|
|
3 |
94 |
|
|
Rolling Speadsheet by
digitaldream
I have a client that wishes to create a rolling spreadsheet. He would
like information from one or more fields on a spread sheet to roll over
to the next sheet...
|
December 31st, 2003 02:06 AM
by Ozzie
|
1 |
99 |
|
|
copy paste inconsistency in EXCEL by
ltl
when I copy and paste a formula from one cell to another.
The relative formula displays correctly in the new cell,
but displays the value from the first cell....
|
December 31st, 2003 05:16 AM
by
|
3 |
483 |
|
|
How to diable "chart tool box" popup by
Kenji
Each time I click on the chart on my excel sheet, I get a "char tool box"
pop up. It happens on other people's computer as well. Is there a way to
disable...
|
|
1 |
140 |
|
|
|
December 31st, 2003 08:23 AM
by Wayne
|
14 |
510 |
|
|
|
|
1 |
384 |
|
|
Too many IFs and VLOOKUPs???? by
KrisB_bacon
A friend of mine constructed this function to lookup data on School
Classes depending on the year. As a joke he input Bugger as the last
message. He can take...
|
|
1 |
112 |
|
|
Excel sound alert by
Michelle
How can I create an audible alert sound in an excel
spreadsheet. For instance, if column B falls below the
sum in column A, I would like an alert (sound) or...
|
December 31st, 2003 03:58 PM
by Alfred
|
1 |
126 |
|
|
Changing date format to text only by
Bob Phillips
format using a custom format of 'mmmm dd, yyyy' without the apostrophes.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove...
|
|
0 |
251 |
|
|
printing several sheets as one by
I have several sheets, but not all sheets fill one page
when printed. I would like to append those sheets that
fill less than a page together, so when I print...
|
December 31st, 2003 04:58 PM
by Dan C.
|
1 |
287 |
|
|
Matching data to return value by
Craig
Good Evening and thanks in ADVANCE for looking at my
problem. I am looking for some of the Forum experts to
give me a hand please send me or reply with...
|
|
3 |
422 |
|
|
Far too many "IF"s for my own good by
Jim
My self-esteem is in the crapper; I simply cannot imagine being "good
enough" to help, darn it. Perhaps someone will recommend you try VLOOKUP.
--
Greeting...
|
|
8 |
437 |
|
|
Show file creation date in header by
Amy
Happy New Year to all!
Is there any way that I can show the date that the file
was created in the header instead of the current date.
I've been using...
|
December 31st, 2003 08:56 PM
by
|
2 |
257 |
|
|
Filter by
Mark
How do I filter a worksheet to display only those rows
that match a list?
|
|
1 |
86 |
|
|
|
|
3 |
451 |
|
|
|
|
1 |
372 |
|
|
|
January 1st, 2004 12:49 AM
by Max
|
6 |
496 |
|
|
Match?How by
Krefty
How do you tell one worksheet to take Cell B2 fron for
example CAT worksheet and then tell Excel to find a exact
match on for example the DOG worksheet, and if...
|
January 1st, 2004 01:07 AM
by Max
|
1 |
90 |
|
|
Automatic Cell Text Wrapping by
Annabelle
I'm creating a report form in MS Excel 2000 that will use
several formulas and conditional formatting. In a couple
of sections, I've merged several cells into...
|
|
1 |
375 |