|
|
PivotTable Title by
NonTechie
I have Excel 2007. I have a PivotTable and want to have a title for it. When
I change "Data" to the title I want, it truncates the title in that first
cell....
|
|
2 |
263 |
|
|
|
|
3 |
280 |
|
|
|
|
2 |
317 |
|
|
Open files in seperate instance by
Rick
I want to set Excel to open files in a new instance. For example, if I
double click two xlsx files in a folder and then double-click an xls file
attached to...
|
November 12th, 2009 11:13 PM
by Rick
|
0 |
263 |
|
|
Autofill question by
Gor_yee
Hi there...I need a VBA script that I can use to autofill down a
column...so if row a5 had a heading of "happy" and then z5 had a
heading of sad... I need that...
|
|
2 |
221 |
|
|
IF Statement in Excel 07 by
CandiC
In Excel 2007, I have a dropdown box that contains the names of the states,
Iowa, Illinio or exempt depending on where the work is performed in cell
C125. I...
|
|
1 |
239 |
|
|
divide by zero error by
susancca
getting the divide by zero error with this formula
=IF(F175=0,0,+F175/L155)
F175=sum of cells equaling 4
L155=sum of cells equaling 0
any help?
|
November 12th, 2009 09:04 PM
by susancca
|
5 |
229 |
|
|
Data Validation using dependency logic by
maitri
I would like to be able to limit the available options in a drop down list
dependant on the selection made in the previous column.
Specifically I have 4...
|
November 12th, 2009 08:57 PM
by Luke M
|
1 |
305 |
|
|
Concatenate formula by
Bricky
I'm trying to get a formula using concatenate that will identify numbers in a
row 3 (4&5) and returning the name of the column above into one cell.
Big ...
|
November 12th, 2009 08:53 PM
by Bricky
|
2 |
209 |
|
|
copying conditional formats by
Ron
I've created a conditional format that colors red cell A1 if the value of
cell A1 is less than cell B1. Next, I copied this format into the cells
A2:A100. ...
|
November 12th, 2009 08:01 PM
by T. Valko
|
1 |
202 |
|
|
Return Column match by
Charp
I need to return data from a specific column within multiple columns. For
example, I would like to return data from the Mar column by row.
Description Jan ...
|
November 12th, 2009 07:55 PM
by T. Valko
|
1 |
231 |
|
|
Linking Password workbooks by
debinnyc
I have tried to read some of the topics on the subject, but I can't figure
out if there is a way to update a master spreadsheet that has links to
password...
|
|
1 |
264 |
|
|
|
November 12th, 2009 06:22 PM
by MICHALK
|
16 |
346 |
|
|
manage tags for microsoft office 2007 by
jing.liang
Hi, I have a question about the new "tag" property in Microsoft office 2007.
I am wondering whether I can create a nested "tag", for example:...
|
|
0 |
207 |
|
|
|
|
1 |
281 |
|
|
|
|
2 |
247 |
|
|
Cell reference by
sc
On the below formula I would like to count if the data in A6 is contained in
A7 where A7 may have more data.
=COUNTIFS(A6,"=" & A7)
Specifically, A6 may be...
|
November 12th, 2009 05:39 PM
by sc
|
3 |
232 |
|
|
|
|
3 |
268 |
|
|
Quickbooks export to Excel 2003 by
Mike2010
Hello,
I use Office 2003 on my computer. I recently downloaded the Office 2007
trial. After a few days, I used the add/remove programs from the control...
|
November 12th, 2009 05:00 PM
by Mike2010
|
0 |
231 |
|
|
Keycode description creator by
Beeatrice
I have a feed of approximately 2000 keys. Each key has 4 positions. Each
numeric position within the key represents different criteria. Please take a
look...
|
|
2 |
240 |