|
|
|
July 7th, 2004 09:50 AM
by wuming
|
2 |
381 |
|
|
|
|
2 |
163 |
|
|
Combo Box- Character Look Up by
201blue3
Excel VBA Look Up
I have written a macro to look up data from several other worksheets.
Now I want to use that summary and create specific reports (by VP,...
|
|
1 |
220 |
|
|
Increase Size Of Auto Fliter Drop Down Box by
Mathew
Good evening all,
I am looking for some code so that I can increase the Depth of the auto -fliter drop down box, ie to increase the number of entries
visible,...
|
|
1 |
405 |
|
|
Adding the # of rows, not the contents... by
Charlie O'Neill
Jacob,
Try changing the 'sum' function in the subtotal bar to 'count'. Or add a
formula, for example if the customers are listed in Column A, then in...
|
|
4 |
196 |
|
|
separating data in cells by
cw
I have a very long excel spreadsheet with data like this in each cell:
Alaska Native Medical Center
4315 Diplomacy Drive
Anchorage,**AK**99508 Phone: (907)...
|
|
4 |
146 |
|
|
|
|
1 |
405 |
|
|
|
|
3 |
664 |
|
|
|
July 7th, 2004 01:25 AM
by hgrove
|
2 |
651 |
|
|
spreadsheet does not open properly by
Julie M.
This problem is happening on my work computer as well as my home computer. When I click on an excel file to open, excel opens but the area where the...
|
July 7th, 2004 12:26 AM
by elise
|
2 |
195 |
|
|
Excel by
Tony
I need help? I have a list of names which need a lot of figures to be entered onto a worksheet. The work sheet is vey large and covers some 7 pages on the...
|
|
3 |
309 |
|
|
4th July Rules! by
Norman Harker
G'day!
Since the USA is supposed to be on holiday, how about rules for what
the rest of us will do today?
Suggestions to kick off with.
1. Start off with a...
( 1 2 3 ... Last Page)
|
|
52 |
2,523 |
|
|
String manipulation by
Jack Schitt
Hi all
Please could someone give me a formula that strips out all non-numeric
characters from a string variable contained in a cell, and returns a
numerical...
|
|
9 |
395 |
|
|
MROUND function by
Sherry
I am using Excel 2003 (Office 2003). I am trying to
utilize the MROUND function, which should allow me to
round to the nearest multiple of a number. However,...
|
July 6th, 2004 09:32 PM
by
|
2 |
310 |
|
|
Conditional Format? by
cathy
I have set up a worksheet that requires me to update any cells with a background color of yellow. I would like to have the cell return to a white background...
|
July 6th, 2004 09:30 PM
by cb
|
2 |
175 |
|
|
Pivot Table: Misordered date Grouping by
Mark G.
I'm having a problem where the grouping is coming out
wrong. I have dates ranging from October 2003 to June
2004. When I group by month, it gives me a...
|
|
3 |
336 |
|
|
Deleting with an IF Statement by
garungaha1
Hello Everyone,
I am trying to write an IF statement that will delete certain rows if
they match the false criteria.
Ex.
IF cells A7:A12=500, if true keep...
|
|
6 |
193 |
|
|
Summing with a range of number by
garungaha1
Hey Everyone,
I have a question about summing via ranges. I am trying to write a
macro and have hit a bump.
Here is the scenario. I have a 2 columns of data...
|
|
4 |
260 |
|
|
Create unique list from duplicates by
Raeven
The solution for this is probably a quite simple array formula with
COUNTIF, but I cannot seem to get it exactly right. All I want to do
is take a list with...
|
July 6th, 2004 09:01 PM
by Raeven
|
4 |
433 |
|
|
Pivot Table Data Source by
Kirk P.
I have several tables that use various queries stored in Access as the data source for my Pivot Tables.
Question is, after the Pivot Table is set up, is there...
|
|
1 |
439 |