|
|
TROUBLESHOOTING VLOOKUP - PASTE NEW VALUES by
Charlie Marcous
I have a workbook where column "I" looks up the value
in "J" in another worksheet and returns a correct value
for column "I" which works for 400+ rows just...
|
|
1 |
718 |
|
|
Changing A1 to $A$1..... by
43fan
Is there any way to change a set of cells all at one time? The entire
equation?
I'm copying cells from one area in the worksheet to another, and I don't
want...
|
September 17th, 2003 11:31 PM
by jr
|
3 |
297 |
|
|
Split Combined Name by
dlaw
Cell A contains a name in the format 'first initial last'.
I want to create cells from this: 'first' 'initial'
and 'last'.
Are there formulas for the 3 cells...
|
September 17th, 2003 11:14 PM
by mr
|
1 |
437 |
|
|
This directed to John Wilson/or anyone else by
Radio848
Hi Guys & Gals:
John provided me with the enclosed macro, (I have made modifications, so the
problem isn't his fault)
Problem: I can only get the enclosed to...
|
September 17th, 2003 11:09 PM
by Radio848
|
6 |
389 |
|
|
Formula Help by
SFrick
In row 5 i have text, positve and negative numbers.
I need a formula that will return 1 when the cell above in row 5 is
positive and 0 when it is negative or...
|
|
1 |
258 |
|
|
revision number of excel worksheet.. by
PhantomSteve
Is there any way I can get a cell to show the revision number of the
current document (ie how many times it has been saved)?
In Word, this is done by...
|
|
1 |
404 |
|
|
macro - hide rows by
Will
I will try this again but I do not understand all the
lingo so please lead me.
Cells A2:A60 contain formulas that return a result of
either "" or a number....
|
September 17th, 2003 10:18 PM
by Will
|
3 |
445 |
|
|
Worksheets by
Walter Payne
My worksheet is long. How do I divide it and still have
the information linked to the first page.
|
|
0 |
236 |
|
|
Remove Spaces by
Bryant Caldwell
How can I use a function to remove spaces from a string.
Before
Smith , Bob
After
Smith,Bob
Thanks,
|
September 17th, 2003 10:05 PM
by Lynnus
|
3 |
435 |
|
|
Copy subtotals by
Erin Paulin
You just saved me a TON of work!!
Thanks for the very helpful post!
Erin
-----Original Message-----
If this has to be done often, there is an icon which...
|
September 17th, 2003 09:50 PM
by RagDyer
|
1 |
684 |
|
|
Spreadsheet play file then close by
Brenda
I need to create a workbook that will play a .wav file
then automatically close. Is there anyway to do this
without having "Enable Macros" dialog box pop up...
|
|
2 |
336 |
|
|
Linking by
Dawn
When doing a link to another program, borders are
missing. Any way to fix this.
|
September 17th, 2003 09:33 PM
by Dawn
|
0 |
263 |
|
|
Custom Template Worksheet Location by
brohar
I cannot for the life of me get my custom template
worksheet to show up in the same location as the default
xlt files. My PC is a company machine but my help...
|
September 17th, 2003 09:27 PM
by Radio848
|
3 |
504 |
|
|
trendline equations are incorrect by
Fred
I charted a set of coordinates. The polynomial equation
fit extremely well (r square = 0.99) Unless I'm doing
something wrong, (and I don't think I am; I had...
|
|
3 |
438 |
|
|
Pooled regression and dummy variables by
Kev Summersgill
I'm a bit of a novice with excel. I have a dataset of
national ststistics which only has a few years so I can't
run a time series regression with any...
|
|
1 |
698 |
|
|
Autofill formulas b/t various worksheets by
lbenson
Hello-
I have a workbook w/ 25 worksheets.
I need to sum the same cell from each worksheet and put it on a
separate summary worksheet. I tried to use the...
|
September 17th, 2003 09:15 PM
by RagDyer
|
3 |
476 |
|
|
Data Validation by
dinna
can anyone help me !!!! I am trying to create a drop down list in excel
with data from another tab. Is this possible, if so how can I do...
|
|
1 |
288 |
|
|
unhiding Column A - help! by
Phil
I've run into an odd problem. I did a Hide on Column A
and B. Excel won't let me unhide a column unless I
highlight the columns on BOTH sides of it. I have...
|
|
1 |
310 |
|
|
Excel database query by
Jean
I am using Office 97. I recently moved an access
database from one network drive to another. I have an
excel database query to that database that no...
|
September 17th, 2003 09:03 PM
by Dave
|
1 |
387 |
|
|
Spherical Coordinates by
Keith Ingstrup
Given: Radius, inclination(in degrees) and azimuth(in
degrees). Can excel calculate P(x,y,z)
|
|
1 |
347 |