|
|
|
June 4th, 2010 05:28 PM
by Billns
|
2 |
929 |
|
|
vlookup formula errors by
BG Mark
I am trying to enter a vlookup function into a cell to look at data in
another work book, but after entering the initial lookup reference followed
by the...
|
|
5 |
970 |
|
|
excel 2007 saving issues by
CXH
I have a file created in excel 2003 that has thousands of VLookup functions.
I recently installed excel 2007. When I open this file and try to save it,
it...
|
June 4th, 2010 06:52 PM
by CXH
|
0 |
819 |
|
|
permanent format pivot chart by
amz
How can I apply a format permanently in a Pivot Chart? For example, adding
values to my data graphs and not losing this format upon changing a field to...
|
June 4th, 2010 06:57 PM
by amz
|
0 |
1,002 |
|
|
|
June 4th, 2010 07:25 PM
by John
|
2 |
970 |
|
|
Pivot Table by
KTR
I have a pivot table based on an excel worksheet with five columns - Date,
Call From (Names), To, Time, and Type.
In the pivot table, i am using From for the...
|
|
1 |
995 |
|
|
Text Parsing with uneven lengths by
dks345
I have cells that contain data such as:
General Motors 22779
United States of America 1449
Carlsbad 712
Under 21 Children 12
I would like to parse the...
|
|
2 |
998 |
|
|
|
June 4th, 2010 08:13 PM
by Vicki
|
2 |
1,047 |
|
|
|
|
2 |
1,104 |
|
|
|
|
1 |
959 |
|
|
|
|
1 |
1,013 |
|
|
Sumproduct;3 criteria by
GregL
Hello,
I need a formula that will sum the dollar value of a column if the entries
meet 3 seperate criteria.
The current formula I have (that returns a #NUM...
|
|
5 |
1,366 |
|
|
data conversion by
Candida
Please advise how I can convert a number that comes over as '40593 from our
Italian firm. How do I take the ' off of the number. I have 3000 rows of
numbers...
( 1 2)
|
|
11 |
1,307 |
|
|
|
|
1 |
816 |
|
|
Macro to affect all sheets by
REMB
I want to select all sheets in a workbook, insert a column, and put a formula
in that column. It works fine when doing it manually, but if I try to have a...
|
|
3 |
882 |
|
|
Pull value from another sheet by
laughlinl
I have multiple sheets in my workbook. On the first sheet, I am pulling data
from all the other sheets for a comparison. I need to pull in a commission
level...
|
|
2 |
997 |
|
|
Printing in Color by
Fill Colour for Different data
Ever since my printer has been networked by the cells in my excel if filled
with color do not print in color. The print preview displays the various
colors...
|
|
0 |
925 |
|
|
|
|
1 |
1,032 |
|
|
SUMIFS by
RAK
My SUMIFS formula was "accepted" but the result is 0.0 even though there are
numbers to add. What can the problem be?
The formula is...
( 1 2)
|
|
10 |
1,493 |
|
|
Set row height, but allow wrap text by
KMM
I want to set the row height of me spreadsheet to allow a little "buffer"
between rows. But I have a couple rows in which there is a greater amount of
data...
|
June 4th, 2010 11:01 PM
by KMM
|
0 |
957 |