|
|
|
|
2 |
166 |
|
|
cell to stay same by
Pammy
If I enter a 2 in a cell, I want it to always show as a -2.
Anytime I type 2, if comes in as -2. Is there a way to do this?
|
|
2 |
164 |
|
|
|
|
2 |
167 |
|
|
Importing Access database into Excel 2007 by
confused_student[_2_]
I'm having difficulty with Excel recognizing information from an Access
database that's been imported and added to an existing Excel 2007 table.
Excel...
|
|
1 |
139 |
|
|
Deriving winners from a list by
Harold
I have an excel worksheet where one column is a list of names and the next
column either has the word "winner" or "loser". There is only one "winner",
so...
|
November 9th, 2009 10:00 PM
by John
|
4 |
143 |
|
|
Turn off prompts by
Keith
I have an excel spreadsheet that will run a query on the database, when open.
The first time I ran it, a pop up window displayed about enable/disable
query,...
|
|
1 |
143 |
|
|
|
November 9th, 2009 07:49 PM
by Doug
|
0 |
132 |
|
|
|
|
0 |
143 |
|
|
|
|
9 |
181 |
|
|
Pulling Data from other excel workbooks? by
Frustrated
I need a little help. I need to pull data from one excel workbook (A) and
display the data on another excel workbook (B) but i only want to pull the
date if...
|
|
5 |
193 |
|
|
|
|
0 |
142 |
|
|
Sharing or Emailing Macro by
AJOLSON
I have a macro in Excel that I want to emial or have another user import into
their excel spreadsheet. How do I do this?
|
|
1 |
132 |
|
|
relative defined name references? by
Gant
I'm trying to copy an excel template that has naming references included.
Is there a way to copy the template to a new worksheet within the existing...
|
|
1 |
150 |
|
|
Calculating acruing interest by
DRKENNE
I'm looking for a formula (simple I hope) that would calculate interest
that's been accruing at an annual rate of 10% on $10,500 that should have
been paid...
|
|
4 |
160 |
|
|
Formula Question by
Matt
I have specific status codes in Text Format in Column B of my workbook. I'm
wanting to setup a formula that will calculate the average of one status
marked...
|
|
2 |
116 |
|
|
lock not working in Excel 07 by
vpinnell
Lock works on some cells in my worksheet but not on others. I complete the
lock of the cells and protect the worksheet but the lock is not working. The
cells...
|
|
0 |
124 |
|
|
Is there an AVERAGEIF function in excel? by
lisab
I'm trying to average the values in one column if another column's value is
true. I know there is a sumif and a countif, but couldn not find an
averageif....
|
November 9th, 2009 06:46 PM
by Luke M
|
5 |
141 |
|
|
|
|
4 |
165 |
|
|
|
|
2 |
126 |
|
|
VBA filter ? by
Mike
So I am trying to create a macro that filters a list and paste the filtered
results into different tabs for certain groups I am filtering. Some months...
|
|
1 |
140 |