|
|
=IF formula #NAME? error by
Access101
All three of these are wrong, I can't think of a fourth:
=If(instr(A1, "test"), "Y", "N")
=If(instr(A1, "test")=-1, "Y", "N")
=If(instr(A1, "test")=True, "Y",...
|
December 1st, 2006 01:54 AM
by Max
|
1 |
63 |
|
|
|
March 1st, 2006 01:39 AM
by Max
|
3 |
189 |
|
|
Trying to compare data in two columns... by
accessgrits
I have two columns of data, one for serial numbers I have sent out, and one
where extended warranties that were purchased. Instead of always using the
find...
|
May 12th, 2005 06:32 PM
by Biff
|
5 |
97 |
|
|
now() by
AccessHelp
Good morning,
How can I make the now() function static?
What I am trying to do is we submit our timesheet every week. I have a
macro set up to write the...
|
October 27th, 2005 08:51 AM
by topola
|
5 |
179 |
|
|
Cell References by
accessnovice
I would like to be able to click in a cell and have it take me to another
page in the workbook - Any suggestions? Thank you.
|
|
3 |
92 |
|
|
|
August 28th, 2006 01:36 PM
by shail
|
2 |
49 |
|
|
|
May 17th, 2005 09:23 AM
by
|
3 |
91 |
|
|
|
|
1 |
85 |
|
|
|
|
1 |
67 |
|
|
Sheet Names by
Accor
Hi all
I have a spreadsheet with around 20 sheets; sheet1, sheet2, sheet3 etc.
Is there any shorter way to re-name them either from a list or let's say
call...
|
|
4 |
105 |
|
|
excel 2003 by
account via OfficeKB.com
am having a problem with a formula: It says to do under data, validation,
and in settings under allow choose custom then in the formula box, this is
where the...
|
|
2 |
126 |
|
|
Adding duplicates... by
accountant
I need help figuring out a formula to add duplicates as follows:
I have 3 months of figures with duplicate names on each month. I need to
add these amounts...
|
July 23rd, 2008 10:40 PM
by Spiky
|
1 |
78 |
|
|
Formula for adding 2 worksheets by
accountant
I need to consolidate 2 worksheets on another separate sheet. What kind of
formula can I write that would include new names on the 2nd worksheet. Say,
the...
|
|
1 |
80 |
|
|
combo box by
Accountant
How do you add the scroll bar to the combo box?
|
September 14th, 2007 12:48 AM
by FSt1
|
1 |
57 |
|
|
|
September 30th, 2005 12:53 AM
by Paul B
|
1 |
84 |
|
|
functions/formulas by
AccountantPB
How do I reference the formula above and get the result off 101 rows below
that formula? I need to reference every 101 st row but put the information
one row...
|
|
2 |
130 |
|
|
FILTERS by
ACCOUNTING GAL
WE HAVE 15 PEOPLE SHARING AN EXCEL WORKSHEET WITH ABOUT 12 COLUMNS. DATA IS
CONTINUALLY ADDED ALL DAY LONG. FOR SOME REASON THE FILTERRING TABS WE SET UP
IN...
|
|
1 |
61 |
|
|
Statutory Hrs Calculation by
Accounting Student in BC, Canada
I have a payroll timesheet tracking hours worked, with rows corresponding to
the names of employees and columns corresponding to dates of the pay period
(14...
|
|
0 |
123 |
|
|
copying formulas only by
AccountingStudent
i have windows vista and excel 2007. I created an IF formula in one cell and
want to use the same formula down the column but referencing other...
|
|
1 |
56 |
|
|
scroll with arrow keys problem by
Accounts Diva
When using the arrow keys to scroll down a spreadsheet, I find the active
cell disappears below the bottom of the screen. I have to use the scroll bar
at...
|
|
1 |
64 |