|
|
if, index, match by
rsikin
I am setting up a payroll journal entry in Microsoft Excel 2000 (PC)
(Col A) (Col B) (Col C)
(Col D)
Employee Gross ...
|
July 6th, 2004 07:11 PM
by rsikin
|
3 |
145 |
|
|
lookup formula by
gregork
I am trying to come up with a formula that looks up an order number (eg
2013864) on a list on another sheet (2)and then returns all the listings
corresponding...
|
|
8 |
169 |
|
|
Missing toolbar by
Roger Bedford
Am looking for the toolbar in Excel 2002 that shows the cell range and any
text that is currently being typed. Any suggestions would be appreciated.
Roger
|
|
1 |
381 |
|
|
|
July 6th, 2004 08:26 PM
by jeff
|
1 |
189 |
|
|
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 |
449 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
341 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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,566 |
|
|
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 |
|
|
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 |
|
|
|
July 7th, 2004 01:25 AM
by hgrove
|
2 |
652 |
|
|
|
|
3 |
664 |
|
|
|
|
1 |
405 |
|
|
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 |
|
|
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 |