|
|
MATCH within INDEX question by
Ron H
Hello,
In a previous thread I got a nice solution to a lookup problem I had
with the INDEX/MATCH functions.
I would like to learn exactly what the formula...
|
|
9 |
650 |
|
|
merge and wrap by
David Fore
I'm formatting an excel spreadsheet.
I'm using merge horizontally to get comments spread across multiple
cells.
I.E.
name ______ comapny _______ date...
|
June 13th, 2004 10:22 PM
by Ragdyer
|
3 |
371 |
|
|
VB to filter a list by
CrankyLemming
Hi
I have a worksheet containing a list of businesses, their addresses,
phone numbers, and so on, and also a column which specifies the type
of organisation:...
|
|
4 |
399 |
|
|
conditional formatting by
reno
on a amotization sheet that may run to 240 payments, payments may start in any month and the first payment would be in about row 40 or so. want to highlight...
|
June 13th, 2004 11:49 PM
by Domenic
|
1 |
333 |
|
|
|
|
3 |
502 |
|
|
|
June 14th, 2004 02:26 AM
by Edo
|
8 |
449 |
|
|
Can't delete file by
gary
I have an .xls file that I CAN'T delete. (No matter how I
try to delete the file, the application I'm using locks
up). How do I get rid of the file?
|
|
2 |
391 |
|
|
TRIM spaces by
jh
I have first name and last name in one cell. Between the
first name and last name, there is a space. I want to put
the first name in one cell and the last...
|
June 14th, 2004 04:08 AM
by jh
|
4 |
477 |
|
|
Macro Help - Jumping Sheets by
Nick
Hi All
I have a workbook which contains 400 sheets. What I need
to do is to insert a "cover" sheet and then create a macro
to pick up the same four cells...
|
|
1 |
559 |
|
|
why? - Ctrl+ F11 and sheet names by
JulieD
Why when i use ctrl + F11 to insert a worksheet does it call the worksheet
"Macro 1", "Macro 2" etc instead of Sheet x ... ?
just wondering
Regards
JulieD
|
June 14th, 2004 04:18 AM
by JulieD
|
5 |
511 |
|
|
"calculate" at bottom of worksheet by
bruno
"calculate" appears at the bottom of my worksheet. It
seems to be some type of circular reference and some of
my formulas are not being calculated, even when...
( 1 2)
|
|
11 |
718 |
|
|
Include formatting in a formula by
Ceci
Thanks, Dave and Mark.
Mark, since the entire formula is in one cell and I want to bold and underline certain parts of the result, I cannot bold and underline...
|
June 14th, 2004 07:24 AM
by Ceci
|
2 |
407 |
|
|
Indirect Addressing of Worksheets by
sandbag
Probably an easy question, but I can't find the answer in the Excel Help
files.
I want to be able to construct a worksheet reference from the contents
of a...
|
June 14th, 2004 08:10 AM
by sandbag
|
6 |
408 |
|
|
formula help!! by
Mike Kasiorek
Hello there, I am desperate for some help on a excel project....basicaly
I have 2 columns, one will be a "Y" and the other a "N"...I need to come
up with a...
|
|
2 |
343 |
|
|
User Defined Function by
dovrox
How would I write a MinIf function that could be used in the spreadsheet
in the same way the "CountIf" function is used.
It would be great to be able to min a...
|
|
2 |
631 |
|
|
Arrays by
ryan wells
Hello...
I was be so grateful if some Excel Expert could offer a solution to
this problem I have understanding how to handle arrays in Excel.
I have a...
|
|
5 |
692 |
|
|
Averaging compound numbers by
Old Red One
Is there a formula for obtaining an average of a series of compound numbers,
such as blood pressure readinags, e.g. 140/80?
|
|
4 |
520 |
|
|
Returning Worksheet Name by
sandbag
Another simple question...
How do you reference the name of the current worksheet?
For example:
if the current worksheet is called "Week1", I would like to...
|
|
5 |
374 |
|
|
is it possible to sort by rows? by
boydie
I am attempting to sort a set of data by rows. So far the only way i
have been able to do this is by first transposing the data, sorting in
the normal way and...
|
June 14th, 2004 01:30 PM
by Domenic
|
2 |
465 |
|
|
Please help by
David
Office 2000
Excel caused an invalid page fault in module kernel32.dll
at 0167:bff8d5a3
|
|
1 |
381 |