|
|
using pivot table by
reza
dear all,
i have table with 100.000 rows...
column a (no) column b (customer) column c (cities name)
1 reza new york
2 bob ...
|
March 9th, 2010 04:04 PM
by shaz
|
3 |
170 |
|
|
|
|
0 |
191 |
|
|
|
|
4 |
200 |
|
|
Formula to add spaces in csv by
Wet Nose[_2_]
I'm changing email programs and am trying to import client data. The old
program will allow me to export this data as csv only. The new program will
import...
|
March 9th, 2010 03:45 PM
by Bob I
|
4 |
205 |
|
|
text & formual problem combined by
David
When I combine text and a formula - i.e. ="Avg "& SUM(D30) - it comes out as
Avg 0.286253661284266 but I only want it to 2 decimal points!
The D30 cell...
|
|
6 |
148 |
|
|
|
March 9th, 2010 03:34 PM
by JLatham
|
1 |
195 |
|
|
Cell Formating by
Walter
Update to previous!!!! It is the date I am having trouble with? the
previous formatting offered the diplay option of Tuesday March 9, 2010 and
would...
|
|
3 |
176 |
|
|
|
|
1 |
156 |
|
|
|
|
1 |
185 |
|
|
Count Highlited Cells by
Vic
What is the formula to count Red highlighted cells in the range F2 thru S412?
I also need formulas to count separately Yellow and Sky Blue cells in the
same...
|
March 9th, 2010 01:55 PM
by Paul C
|
3 |
190 |
|
|
|
|
1 |
177 |
|
|
Charts in 2007 by
Steve
Is it possible to freeze the size and locations of Charts in Excel 2007? The
size and location on the worksheets keeps changing. I have tried the
Properties...
|
March 9th, 2010 01:37 PM
by Steve
|
0 |
132 |
|
|
Hidden cells by
HuaMin
Hi,
In the Excel sheet, I've clicked 'Hidden' in 'protection' tab in 'Format
cells' of the cell, and then I protected the sheet. But the 'hidden' cells
that...
|
|
2 |
157 |
|
|
|
March 9th, 2010 01:05 PM
by Max
|
1 |
265 |
|
|
|
March 9th, 2010 01:00 PM
by JLatham
|
6 |
168 |
|
|
|
|
4 |
176 |
|
|
Print one page per sheet by
Very Basic User
Hello,
Can you help me to figure out what to change to have one record printed per
sheet be the standard way my report prints.
--
Thank you for your...
|
|
3 |
183 |
|
|
|
|
1 |
172 |
|
|
Formula result showing 0 by
Rajula Luke - This is my display name
Hello,
I have entered a SUM formula. The cell shows 0 value for all the rows. When
i click on the Function Argument, i can see the actual result. How can i...
|
|
3 |
176 |
|
|
mail failure by
lorraine
am trying to mail one page from excel 2007 but keep getting message 'check
mail installation'. have tried suggestions on the help site without success.
am...
|
|
0 |
141 |