|
|
index and match by
Scott
is it possible to use the index match method with multiple sheets? And how might it be done? I've tried a couple of different things. My Data is quite...
|
|
1 |
289 |
|
|
data ranking by
Bernie Deitrick
Alex,
=INT(A1/10)+1
More generally,
=INT(A1/NumOfLevels)+1
HTH,
Bernie
|
|
1 |
94 |
|
|
Circular reference error - where ? by
Lynn
Thanks Kevin. I'm going to email the file to you. It's a
tough one.....
Lynn
-----Original Message-----
Hi Lynn,
You have to do a bit of detective...
|
|
1 |
371 |
|
|
Function by
Shawna
I have no knowledge of formulas or functions. I have 2
cells with one number in each. In the 3rd cell I would
like to choose the greater of the first 2...
|
November 20th, 2003 03:10 PM
by NC
|
3 |
127 |
|
|
Sum IF by
Arvi Laanemets
Hi
It seems you have some formulas in cells C84, E84 and G84, which sometimes
return #DIV/0
Use in those formulas error checking,...
|
November 20th, 2003 03:35 PM
by Julie
|
3 |
128 |
|
|
|
November 20th, 2003 03:45 PM
by Aron V
|
0 |
529 |
|
|
Add a trailing comma by
Dimitry
I need to add a trailing comma to a number. I have a
column with a few thousands rows in it, and I need to add
a comma to each number. I need to use this...
|
|
2 |
305 |
|
|
VLOOKUP by
bstacy
I cannot get the VLOOKUP function to work for the life of
me. I have never used it before, but I have a perfect
application for its function.
I have one...
|
November 20th, 2003 03:55 PM
by Jim
|
3 |
74 |
|
|
Referencing Cell Colors - Help by
Dj
In referencing cell simply using = , is there a way to get
the color format to transfer over to the new cell? It
seems like a simple request, but I can't...
|
|
1 |
130 |
|
|
Rows and columns changing? by
Anna azan
Is it possible to change worksheet orientation?
Standard is that we have columns: A, B, C, D...
and rows 1, 2, 3, 4, 5...
Is there any trick to have rows: A,...
|
|
4 |
382 |
|
|
|
November 20th, 2003 05:08 PM
by Anders S
|
1 |
114 |
|
|
counting instances by
Rob582
Hi, is it possible to count the whole worksheet by how
many instances of a all numbers occur?
|
November 20th, 2003 06:06 PM
by Dave R.
|
2 |
126 |
|
|
select rows between 2 finds by
djh
I want to select and delete all the rows beginning with a
row containing a cell with certain text and ending with a
row containing a cell with other specified...
|
|
4 |
332 |
|
|
Alternate Startup File Location by
Reese
Why can't users change the alternate starup file location
in excel 2002? If they change it as soon as they open it
back up it goes back to the original.
For...
|
November 20th, 2003 06:47 PM
by Dave R.
|
1 |
313 |
|
|
section break by
vmbrunner@the jacobslawfirm.com
I am creating a work sheet and don't remember how to
insert a section break, I belive that is what it's called.
I want to created two or three different...
|
November 20th, 2003 06:51 PM
by Jim
|
1 |
323 |
|
|
integral calculus by
Bernard V Liengme
AH Ryan,
If only it was that easy! That type of ease is found only with real math
programs like Mathematica. In a spreadsheet you have to do some work. To
fins...
|
|
1 |
98 |
|
|
Increase maximum capacity of text in cell by
Joanne
How do I increase the maximum number of characters allowed
in a cell. I need to include comments that seem to exceed
what is allowed. It will only "autosize"...
|
|
2 |
205 |
|
|
Count function by
I'm trying to count a column with some kind of criteria.
Count if cell contains EL or HC or MM etc.
Can it be done with the countif functions?
Appreciate any...
|
|
2 |
232 |
|
|
Creating user defined function by
David K.
Hello,
I use Excel 2002 and I will appreciate having a detailed
procedure of creating a new user defined function and
storing it in the personal.xls...
|
November 20th, 2003 07:24 PM
by David K.
|
0 |
357 |
|
|
|
November 20th, 2003 08:00 PM
by James
|
2 |
259 |