|
|
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,011 |
|
|
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 |
834 |
|
|
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 |
988 |
|
|
|
June 4th, 2010 05:28 PM
by Billns
|
2 |
956 |
|
|
|
|
2 |
1,966 |
|
|
Vlookup and Hlookup help by
Nikki
I have a situation where I need to lookup Product A but then lookup Company A
in a column that changes.
vlookup("Product A",A1:T25,hlookup("Company...
|
June 4th, 2010 04:43 PM
by FloMM2
|
3 |
1,062 |
|
|
hightlight cells by
sookie
i need to hightlight a cell when i have one birthday in my list
|
|
1 |
871 |
|
|
Delete rows with Symbols by
Shairal
I receive files from China that always has foreign characters, which
sometimes translate to symbols or ASCII characters in it. I would like to be
able to...
|
|
0 |
915 |
|
|
How to filter for Dates prior to Today by
Tommy
If I have two columns of information or mutiple columns and column A is the
date an event happened or will happen, how would write a formula to say if
the...
|
|
1 |
933 |
|
|
Pick list width changes by itself...why? by
Joe M.
I have some columns with the width 4. Sometimes the validation pick list is
wide like 40 and sometimes it is only as wide as the column. I already know...
|
June 4th, 2010 02:58 PM
by Joe M.
|
0 |
938 |
|
|
Formatting Dates from Text to Numbers by
Tommy
I receive data daily with dates in the following formats: dd/mm/yyyy,
d/m/yyyy,d/mm/yyyyy, or dd/m/yyyy... The values actually are text vs.
numbers. ...
|
|
2 |
886 |
|
|
Excel Text Formula by
Grizz
I'm combining text from four different cells into one cell, which works well.
However, I would like the information from one of the four cells to be Bold...
|
June 4th, 2010 02:23 PM
by Grizz
|
2 |
933 |
|
|
Sum a range based on a column by
Metro
In column A I have subaccount numbers which may repeat. In columns B thru F,
there are amounts that I need to sum if they meet the specific criteria of
what...
|
June 4th, 2010 02:21 PM
by Metro
|
2 |
940 |
|
|
|
June 4th, 2010 02:12 PM
by steve
|
7 |
1,003 |
|
|
|
|
1 |
1,211 |
|
|
|
June 4th, 2010 01:46 PM
by wal50
|
5 |
1,133 |
|
|
Excel calculation problem by
scarmalt
I think something in Excel 2007 is trying to be too clever by half (or is it
a bug?).
Col A Formula Result Expected
...
|
|
2 |
1,442 |
|
|
Conditional Formating by
Going Crazy with excel[_2_]
I have developed a rule for a column of data.
=$ak$7:$ak$11
=$ak$4:$ak$6
I want to repeat this same rule to adjacent columns, AL thru AS.
Then I want to repeat...
|
|
9 |
1,175 |
|
|
|
|
1 |
854 |
|
|
Automatic design for Excel by
גיא
hi
i am using a 3rd party system, that is exporting excel reports. i need to
send these reports to customers, so they neeed to be designed in the same way.
is...
|
June 4th, 2010 11:27 AM
by גיא
|
0 |
795 |