|
|
conditional formulas by
DJK
I am trying to track data by using a reference in a separate column. For
example, If cell A1="Victor" I want to deduct the data assigned to him in
cell B1...
|
|
2 |
229 |
|
|
Goal Area by
wcurtis
How do I add an area to a 2007 chart that shows the goals we are trying to
acheive?
I have a column chart with twelve months and need to have a horizontal...
|
|
2 |
196 |
|
|
yearfrac sometimes does not work by
StevenJJ
I am using Excel 2003. yearfrac sometimes displays an error message.
Sometimes restarting excel the function works properly but other times I have
to restart...
|
|
0 |
202 |
|
|
Sum with IF and IF/Where by
Marco
Hi. I need to sum in excel some values where one of the criterias is the
Employee number and the other is if the Date column is equal or bigger the is
last...
|
|
1 |
224 |
|
|
need a vehicle loan amortization by
roseakatina
iI +-need a vehicle loan amortization template that I can input the actually
date paymts are received. The template that are provided amortizes the loan
as...
|
|
3 |
185 |
|
|
Excel Number Format Question by
snolte
How do you keep the zero in front of a number when the cell is formatted as a
number(example 01423)? This needs to stay formated as a number for importing...
|
|
1 |
183 |
|
|
ActiveX ToggleButton Reset by
John
I have a sheet with several hundred ActiveX Toggle buttons. After running
some code, I need to reset them all so their value = False. Is there a way to
do...
|
|
2 |
190 |
|
|
calculating dates by
future spreadsheet master
I'm wondering if I am able to calculate a date based on two different cells.
A1 is my actual start date 6/28/2006
C1 is the current date (ex 5/13/2009)
B1- I...
|
|
3 |
205 |
|
|
|
|
1 |
369 |
|
|
lookup a value across 15 rows by
NotanExcelGuru
Here is my problem -
The need to look a certain value say 'desktop' across 15 columns ( 1 row)
and if it is present in any one cell, in the 16th column I...
|
|
2 |
243 |
|
|
Design Mode button by
rodlmiller
My coworker and I share a macro-enabled file with some command buttons linked
to macros that sorts a column according to different criteria. It works fine
on...
|
|
1 |
173 |
|
|
Pivot Tables by
Janet
Hi - can someone please tell me how to get the data i drag from the pivot
table field list to the values field to line up underneath each other instead
of...
|
|
1 |
189 |
|
|
Odd Remove Hyperlink Behavior by
Bob
Hi,
I am trying to figure out why sometimes when I select multiple hyperlinks I
can right click and get the Remove Hyperlink command, but for other...
|
May 13th, 2009 10:28 PM
by Bob
|
0 |
235 |
|
|
Formula Question by
John
Is there a formula that gives you the number of business days in a month
(mon-Fri) I have a date in a column A , and I would give to write a formula
in...
|
May 13th, 2009 10:20 PM
by John
|
6 |
185 |
|
|
|
May 13th, 2009 10:04 PM
by Mike
|
6 |
182 |
|
|
Reformat Row to Column by
Fellow Wanderer
Is there an easy way to quickly change data that is in a row to a column or
vice versa?
Example:
Jan Feb Mar
convert to:
Jan
Feb
Mar
|
|
1 |
212 |
|
|
|
|
2 |
249 |
|
|
sankey diagrams in office by
IKI
looking for ways of making sankey diagrams using excel, powerpoint or visio
needs to be simple
preference for excel
|
|
1 |
225 |
|
|
Scrolling in drop down menu by
Marco B
Is there a way to allow scrolling with the mouse in drop down menus created.
I have a drop down menu that has a lot of options and it would be great to be...
|
|
0 |
205 |
|
|
Importing from Peoplesoft by
Louisq
Dear Colleagues,
I am importing a file from Peoplesoft into Excel 2003. There is a green
triangle in each cell. I tried to change to format to General, so...
|
May 13th, 2009 09:00 PM
by Louisq
|
0 |
188 |