|
|
|
June 17th, 2004 04:38 PM
by MJ13
|
7 |
657 |
|
|
Top x per criteria (Function) by
JD
Lets say I have 50 sheets, one for each state. I also have a sheet
that has a years worth of data.
So the data sheet has something like this...
|
June 17th, 2004 04:54 PM
by JD
|
2 |
163 |
|
|
Vba by
walkerdayle
I don't have a clue to using VBA. How do you begin to enter code to
perform tasks? Please Help
Anita
---
Message posted from http://www.ExcelForum.com/
|
|
2 |
165 |
|
|
Sum by Color by
Mark Philley
Someone told me that there was a formula/function that would allow you to
sum cells with a specified background and/or text color. Does anyone know
either how...
|
|
3 |
144 |
|
|
|
June 17th, 2004 05:26 PM
by
|
4 |
205 |
|
|
Format problem by
Todd D
I cannot view on screen cell formats I've made (like
colored shading, patterns, or fonts). I know how to
format a cell and my print-outs show the formats...
|
June 17th, 2004 05:28 PM
by Andy B
|
3 |
146 |
|
|
Accounting format for 0 by
Melinda
I have had the same problem in both Excel 1997 and Excel
2000. I always use the Accounting format which gives a
dash for a 0. However, every once in while I...
|
|
1 |
140 |
|
|
format cell problem by
Hi,
I do not arrive to create this personalized format who is responding to
these 3 conditions
(number is displayed in percentage).
1) if 0 the colour...
|
|
2 |
318 |
|
|
Auto-fill or formula for dates by
dfg
Hi, I've done a couple of searches through excelforum.com, but I can't
puzzle out what I need.
All I need is to fill one column with alternating rows of dates...
|
|
3 |
198 |
|
|
xlCellTypeFormulas, 16 or 23 by
Dennis
Using 2003 home
2000 work
Searched NG's with Google-search
and 2003 Power Programming
for a list of formula cell types.
In short, what does the 23 and/or 16...
|
|
1 |
197 |
|
|
INDEX & MATCH - Help please by
litos_aldovea
I have problem with INDEX and MATCH
I have 3 columns of data, NAME, DATE,TEXT
NAME Date Text
Carlos 1/1/4 Hello
Carlos 2/1/4 Good
Carlos 5/6/4...
|
|
6 |
664 |
|
|
AVERAGE with conditions by
Attila Fust
I am trying to average a range that meets certain
conditions. Here is the example:
worksheet1
A B
-----------------
jan 1 dec 1 ...
|
June 17th, 2004 07:22 PM
by Domenic
|
2 |
142 |
|
|
Search in excell (impossible?) by
Micos3
i want to search in a data base excell, but is usual a dont remenber the whole reference but just a part, is it possible to search for half words only?
Ex:...
|
|
5 |
343 |
|
|
Importing from web page-format by
Kjell Nygaard
Hello :).
I am trying to import a table from a web-page where some of the values are
written for example as 7 -35.
I am making a querry for importing the...
|
|
1 |
127 |
|
|
Remove extra characters from a cell by
Ann
This may be something simple, but does any one now how to
remove leading characters from a cell that was imported
from another system. The first 8 characters...
|
June 17th, 2004 07:45 PM
by Ann
|
3 |
278 |
|
|
Sorting by
Ulf Nilsson
I have a long list of numbers, such as:
106-89-8
141-43-5
197-77-81
50-00-0
When I sort the cells, the 50-00-0 comes either first or
last. I want Excel to...
|
|
4 |
181 |
|
|
|
June 17th, 2004 07:50 PM
by DoctorV
|
2 |
366 |
|
|
scroll speed by
Jason
Is it possible to adjust the scroll speed used when
clicking and dragging to cells beyond the edge of the
screen? I find that more often than not, excel...
|
|
1 |
270 |
|
|
|
June 17th, 2004 08:06 PM
by JRW101
|
1 |
350 |
|
|
blanking out the number zero by
manickmj
Hello I probably have and easy problem,
What I need is to add to a formula that if the answer to the formula is
zero (0) to make the cell blank. I curently...
|
|
3 |
135 |