|
|
|
April 21st, 2009 12:31 AM
by PJFry
|
1 |
109 |
|
|
Unprotect a worksheet by
Mayumdwl
The file I have opened was Excel 2003 version and when I open it in Excel
2007 the sheet is protected. Can you please advice how to unprotect it?
|
April 21st, 2009 12:30 AM
by PJFry
|
1 |
105 |
|
|
|
|
1 |
122 |
|
|
|
|
1 |
129 |
|
|
|
|
1 |
223 |
|
|
Another IF statement question by
Valerie
Hello,
How can I make my IF statement say "=IF(C4=B2+30,1,2)" and C4 is a fixed
date and B2 is the system date (=TODAY() ). I want to add a statement that...
|
April 21st, 2009 12:01 AM
by Valerie
|
1 |
96 |
|
|
|
|
3 |
119 |
|
|
|
|
1 |
91 |
|
|
Mulitple value lookup by
kritter286
Hello
I am having trouble returning some looked up data. I have several
worksheets that I want to pull data from one "User Input" sheet. I am
running into...
|
|
5 |
87 |
|
|
|
|
3 |
122 |
|
|
|
April 20th, 2009 09:54 PM
by SBW
|
7 |
58 |
|
|
Auto Correct Option by
AlwaysQuestions
In Word 2007, I was able to add the Auto Correct option to the Quick Access
toolbar but not in Excel.
Can it be done in Excel?
Any assistance is greatly...
|
|
0 |
73 |
|
|
Hide Rows If Condition True by
wilbursj
Hi
Is it possible to auto-hide a row if a condition is met. Ie If the value of
a specifc cell in that row is 0, i do not want the row to show, so either...
|
|
2 |
63 |
|
|
Excel formula question by
Bill638
I am creating an audit tool that I want to be able to automatically populate
a report with recommendations. I have a Yes/No/NA cell in my checklist
worksheet...
|
April 20th, 2009 07:44 PM
by Bill638
|
5 |
58 |
|
|
|
April 20th, 2009 07:42 PM
by CLR
|
2 |
252 |
|
|
DCOUNT Help by
Rob B.
I am using the output from a combobox as a variable in a database formula
(DCOUNT). The variable is a name. My problem occurs when one name is used
that is...
|
April 20th, 2009 06:48 PM
by Rob B.
|
2 |
71 |
|
|
|
|
2 |
83 |
|
|
|
|
0 |
85 |
|
|
|
|
5 |
114 |
|
|
Value function by
Dave
Hi all,
XL2003.
I have a fraction, say 200/7, in A1.
In B1, I have: =Value(200/7), which returns the right answer.
In C1, I have: =Value(A1), which returns a...
|
|
7 |
61 |