|
|
If Statement Error by
Kiley
I have the following "IF" statement:
=IF('officer
data'!$AV$4="y",'officer
data'!$AR$4,"", IF('officer
data'!$BC$4="y",'officer
data'!$AY$4,"",...
|
May 18th, 2009 10:25 PM
by Kiley
|
3 |
390 |
|
|
|
May 18th, 2009 10:22 PM
by V
|
0 |
173 |
|
|
Comparing 3 numbers by
[email protected]
I'm comparing prices at Baker's, Walmart, and Costco. I've got the
item, unit cost, size, and cost per ounce. I know how to make
comparisons between two...
( 1 2)
|
|
10 |
344 |
|
|
Outlook 2007 Outbox by
CK
I have Vista and Outlook 2007 with 2 mail accounts running. On only 1
account, messages get stuck in outbox. Webmail works fine and I can send
using Safe...
|
May 18th, 2009 10:03 PM
by CK
|
2 |
168 |
|
|
Exclude Sunday & Holidays by
Butch
I am developing a scheduling spreadsheet that will exclude Sundays and
Holidays. I have used 'Workday' in the past, but that also excludes Saturdays
(which I...
|
May 18th, 2009 09:57 PM
by Butch
|
0 |
203 |
|
|
Find and render text within IF Function by
David P.
This one is a little weird but this is what I'm trying to accomplish:
1) Find " CE" in both cells A1 & B1 (note there will only be one instance of
" CE" in...
|
|
3 |
174 |
|
|
|
|
2 |
225 |
|
|
Megastat by
Franc
Why am I having problems installing Megastat on my Excel 2007 Windows Vista?
It runs and then it says checking for previous megastat on excel and then the...
|
|
1 |
267 |
|
|
Need title separated into 2 columns by
Roberta
Instead of the jobcode being one title, need to break manangement title out
to two new columns: Title and Section with title spelled out. Is this...
|
|
1 |
154 |
|
|
Excel Formulas by
ColleenK
I have a spreadsheet with extensive calculations, is there any way to speed
up the calculation process?
--
CK
|
|
3 |
133 |
|
|
|
|
3 |
236 |
|
|
|
May 18th, 2009 08:16 PM
by Luke M
|
2 |
161 |
|
|
auto zero cell data on a function??? by
Resi
hi
wonder if you can help me?
I am (still) developing our staff timesheets. i have now been asked if it
would be possible to add a new function based on our...
|
May 18th, 2009 07:35 PM
by Resi
|
3 |
194 |
|
|
|
May 18th, 2009 07:29 PM
by Elkar
|
1 |
166 |
|
|
"Saving Changes" creates new TMP files by
V
When I answer yes to save changes in my workbook that I have to edit multiple
times per day, it now (all of a sudden) saves my changes to a NEW FILE on my...
|
May 18th, 2009 07:19 PM
by V
|
0 |
229 |
|
|
|
|
0 |
225 |
|
|
Two versions of same file by
Richard Champlin
Why do I get two versions of the same Excel file (xls:1 and xls:2)? How do I
change it back to a normal (without version extension numbers) Excel file?
--...
|
|
3 |
174 |
|
|
Drop down list in Excel by
BillyBoy
I need a drop down to expedite the entry of info. However, I also need the
cell(s) formatted so as to take info not contained in the drop down. How can
I...
|
|
2 |
217 |
|
|
Create single column from multiple columns. by
TraciAnn via OfficeKB.com
Column C has about 400 rows of unique numbers that represent locations.
8 other columns (M, Q, T, W, etc.) have numbers that represent contacts at
those...
|
|
1 |
197 |
|
|
|
May 18th, 2009 06:12 PM
by kyoko
|
3 |
138 |