|
|
|
May 18th, 2009 06:00 PM
by FSt1
|
3 |
178 |
|
|
|
May 18th, 2009 05:45 PM
by Luke M
|
3 |
176 |
|
|
format of zero value by
willemeulen
When changing the cell to accounting format all 0 (zero) values change to -
Are there more options available, in particular I would like it if 0 (zero)
would...
|
|
3 |
147 |
|
|
Multiple listboxes to update pivot table? by
Cam
Hello,
I have a listbox that when selected, update the pivot table (change the
variable pivot field called "Machine") based on the selection on the listbox....
|
|
1 |
231 |
|
|
Data Entry by
jojoba
I want to create a workbook such that users can enter data (using a data form
like page) but once data is entered, it cannot be changed on the spreadsheet.
I...
|
|
4 |
268 |
|
|
|
May 18th, 2009 04:43 PM
by Helenf
|
4 |
152 |
|
|
How to use union reference operator? by
JoeU2004
Why doesn't the union reference operator work below?
Suppose J24:J28 contains 11,20,31,43,53, and K24:K28 contains the text
grp1,grp2,grp3,grp4,grp5.
And...
|
|
4 |
166 |
|
|
Error when copying worksheet by
Mike
I am experience a problem when copying worksheets.
I have a workbook with about 9 worksheets. The size of the workbook is
about 1 MB.
When I right click on...
|
May 18th, 2009 04:36 PM
by Mike
|
0 |
139 |
|
|
Cell Fill Format & Sort Question by
Scott
I have a column with 144 rows. In alternating rows, I have a solid fill to
make the spreadsheet easier to read, especially when printed. However, when
I...
|
|
1 |
172 |
|
|
|
|
1 |
189 |
|
|
MS Excel, Cell-Pionter Options by
Fabco-User
In Ecel, can the cell-pointer highlight the entire ROW and COLUMN as it is
moved around the spreadsheet?
It currently highlights the borders, but it would be...
|
|
2 |
185 |
|
|
Cell Capture Multiple WorkSheets? by
Ken
Excel2003 ... I have approx 90 WorkSheets ... Cell D6 of each worksheet
contains a value I wish to capture in a single worksheet Col. I can select
each cell...
|
|
2 |
183 |
|
|
|
May 18th, 2009 03:48 PM
by K[_4_]
|
0 |
163 |
|
|
|
May 18th, 2009 03:44 PM
by FSt1
|
1 |
218 |
|
|
|
|
2 |
166 |
|
|
|
|
1 |
171 |
|
|
SUMIF is not update why? by
vlook fomula
Dear all,
I am facing problem in SUMIF formula and problem is: I have applied SUMIF
formula and linked with another file not, when I try to open this file it...
|
|
3 |
136 |
|
|
match vlookup function by
Wanna Learn
Hello
A report is send to me has 27 columns and at least 900 lines I need 3
columns
column a name of customer
column c has type of transaction ...
|
|
4 |
157 |
|
|
SUMPRODUCT FOR MULTIPLE SHEETS by
FARAZ QURESHI
How can I use a formula like:
=SUMPRODUCT(--(Jan!$H:$H=$A3)*--(Jan!$J:$J=B$1)*--(Jan!$J:$J=B$2),Jan!$J:$J)
for multiple sheets? Following formula is not...
|
|
5 |
190 |
|
|
Insert to today's date by
SPISO
I have a dashboard type of display on worksheet #1 (Dashboard) where an
individual updates a cell B3 through out the day, everyday, with a new value.
On...
( 1 2)
|
May 18th, 2009 02:11 PM
by SPISO
|
16 |
261 |