|
|
VLOOKUP next greatest value? by
bostitch
I would like to find the SMALLEST value in an array that
is GREATER than lookup_value.
However VLOOKUP returns the LARGEST value in an array that
is LESS than...
|
|
3 |
192 |
|
|
BAHTTEXT by
manharawy
I have a problem working with the BAHTTEXT function in the
Excel,
As i enter the numbers in the box inorder to be shown as
text , the excel displays the text...
|
|
2 |
288 |
|
|
Inserting symbols shortcut by
Warren
Is there a way to provide a shortcut to inserting symbols
in excel. I've only found the cut and paste from the
characer map. Anyone know how to add-in...
|
|
1 |
309 |
|
|
Pause in an Excel Macro by
Harry Bennett
I need to create a macro with multiple functions, one of
which is "SaveAs", so I can save the worksheet to a
different name. How can I record/enter a "pause"...
|
|
1 |
544 |
|
|
Worksheets by
Mike Psarras
How can I locate a value in a worksheet but among
multiple worksheets. I don't want to use find&replace
from edit menu. I prefer to use a function such...
|
|
1 |
172 |
|
|
Hidden worksheets displaying on opening by
randula
I have a problem that I haven't seen before. I have a
workbook that I update and distribute daily. This
workbook contains hidden worksheets that I do not...
|
October 7th, 2003 04:49 PM
by Danny
|
1 |
629 |
|
|
|
|
4 |
434 |
|
|
Columns by
Mark
My colums changed from letters to numbers. Do not know
why. I want hem to be letters. All my worksheets changes.
|
October 7th, 2003 04:12 PM
by Jim
|
4 |
154 |
|
|
Erro message while using move and copy by
Joyce Johnson
I get the error message "No more fonts may be applied in
this notebook" when I try to copy a new spreadsheet. I
need a total of 16 sheets and after 12 I get...
|
|
1 |
168 |
|
|
Floating cells by
sanjay
I need some help with excel and I was wondering if you
could aid me in this regard.
I need to create a floating cell(if that is the right
name) in excel. The...
|
|
1 |
163 |
|
|
Arrays by
Bernard V Liengme
Hi Jan
Assuming you have an extra 0 in the example, this works for me in C1 enter
=MATCH(A1,$B$1:$B$2,0)
Copy down to C8
Best wishes
Bernard
"Jan"...
|
October 7th, 2003 03:10 PM
by Jan
|
1 |
135 |
|
|
Relative Links by
David
I am using an xl spreadsheet as a front end to link data
to other spreadsheets in the same folder. I have no
problem creating the links and getting the...
|
October 7th, 2003 11:28 AM
by David
|
0 |
618 |
|
|
Sumproduct clarification by
Walter Mayes
Various members of this forum have stated that the arrays used in
SUMPRODUCT must be the same.
Excel HELP says, under remarks, in part..."Array arguments must...
( 1 2)
|
|
18 |
442 |
|
|
|
|
3 |
592 |
|
|
Time Sheet function by
John Logan
I need assistance constructing a time sheet for
department employees.
Is it possible to calculate regular time AND overtime from
time start and time end?
In...
|
|
3 |
761 |
|
|
|
|
3 |
346 |
|
|
Excel Cell Limitations by
JD Kronicz
Hi
I am trying to create a large cell in Excel so that people can type
many paragraphs of information. I have done this by merging a number
of cells together...
|
|
3 |
262 |
|
|
random number generator formula by
Dave R.
Have you used the RAND() function?
If i remember right, it may not be installed automatically so you might have
to add it on. But then just use RAND() next to...
|
October 7th, 2003 04:02 AM
by Max
|
1 |
372 |
|
|
Subtotal Mystery by
EU
I added added a SUBTOTAL with COUNTA sub_function
=SUBTOTAL(3,range) and it counts ALL cells in that range
instead of just the non-empty ones. So, if there...
|
|
4 |
185 |
|
|
Spam by
Mike
I posted a message on this site a couple of weeks ago.
Since posting that message I have received a ton of
spam. This is the only site I have posted my...
|
|
2 |
127 |