|
Check if variable contains a string
I'm trying to write VBA code that will look at a String variable and tell me
whether or not that String contains another String — without erroring out.
Variable X contains this string: =SUM(AAAA,BBBB)
Variable Y contains this string: PPPP
I want something that works sort of like this:
If Variable X contains Variable Y, Then Variable W = 1
If Variable X does not contain Variab...
|
6 |
12/22/2008 3:58:02 PM |
|
|
Accounts functions
Hi I have imported data (nominal ledger transactions) from Sage 50 and need
to query the results to total transactions for a particular nominal ledger
code that fall between given dates.
I have attempted to use sumif, but find i can only place 1 criteriea on it
and sumproduct seems to dislike the date range...
|
5 |
12/22/2008 2:58:14 PM |
|
|
Employee Length of Service
Can anyone help please? I want to calculate employee length of service from
start date (A1) where there is a leave date (B1) or (B1) is blank and should
use TODAY as the reference date....
|
6 |
12/22/2008 2:39:48 PM |
|
|
sort Excel 2007 to include empty row between data?
I have a dB of names with a blank row separating each grouping [a, b, c etc],
but every time I sort the list, the blank rows go to the top of the
spreadsheet. Is there a way to keep the empty row in place when sorting? My
interim solution is to end each group with az, bz, cz, etc. Your thoughts are
appreciated....
|
3 |
12/22/2008 2:05:01 PM |
|
|
Datedif
I am having a problem makeing Datedif work in Excel 2007,somebody
mentioned that there is abug in Excel 2007 working with diffrent date
format and it gives a diffrent answer depending on the format. I am
having no luck to give any answer it always returnes #NAME# or
#VALUE#. anybody has an answer to this problem?...
|
4 |
12/22/2008 12:30:08 PM |
|
|
The remote procedure call failed. (Exception from HRESULT: 0x80070
Hi
I have a code like follows.....I am using Windows 2000 server.....to
generate excel template....and i am getting the following error....
=====================================
Exception Type: System.Runtime.InteropServices.COMException
Exception: The remote procedure call failed. (Exception from HRESULT:
0x800706BE)
Source: createtemplate
Page Name:systemdefaults_aspx
Stack Tra...
|
1 |
12/22/2008 12:20:03 PM |
|
|
multiple hyplerlink updating
currently we use a workbook with a sheet for each day of the month, at the end of each day you click on the hyperlink to send the email, problem we have is this hyperlink needs updating all the time and doing it sheet by sheet is a lengthy task.
is there a way of having one master sheet per workbook where the hyperlink can be updated and at the same time it will update all 31 sheets witht he same...
|
2 |
12/22/2008 11:40:51 AM |
|
|
excell automatically protecting a ws
Downloaded a ws and can't edit it due to protection, which requires a
password to remove the protection. Sender insists it's not protected.
Forwarded the ws to my work computer and all's fine. It was NOT protected
My version is Office 2000, works version is Office 2003.
All other ws on the computer are fine....
|
6 |
12/22/2008 8:38:48 AM |
|
|
Calculating Date of next birthday
Perhaps a strange type of request however I have a list of 500 birthdates
and I need to calculate 30 days before the next birthday for each and
display that as a date. I'm using excel 2003 for windows and excel 2004 for
mac.
I can calculate the age as at the next birthday in years and of course the
current age. What I can't seem to figure out how to do is calculate the date
of the next bi...
|
3 |
12/22/2008 6:33:44 AM |
|
|
Find lowest total of cells in range without sorting
Hi, I have a long list of numbers in a column. I want to find the 5
together that have the lowest sum but do not want to sort them. i.e.,
the lowest total of the five as they are arranged on the spreadsheet
now. I thought I had done this previously and it wasn't that
difficult but now I cannot for the life of me remember how or even if
I did accomplish it! Any help appreciated.
Excel 20...
|
6 |
12/22/2008 2:31:45 AM |
|
|
vlookup and multiple ifs
I have one data sheet with information in columns a-j
i have a separate report that i need to populate from the data sheet
i need a formula that will go look for "charlotte" in column b of the data
sheet and if found then look for "customer assistant" in column d and if
found then find "job seeker" in the same data sheet and if found return the
value listed under "job seeker" to the re...
|
9 |
12/22/2008 12:14:00 AM |
|
|
SUMPRODUCT QUERY
I am trying to provide some details on a daily changing set of data on sheet
GBP. The data table shows date (col A), customer ref (col D), amount (col H),
hold reason & team responsible.
I currently use the following to calculate the value of records dated
27Nov08 that have a blank customer ref:
=SUMPRODUCT((GBP!A2:A60000=DATE(2008,11,27))*(GBP!H2:H60000)*(GBP!D2:D60000=" "))
I need to...
|
2 |
12/22/2008 12:06:01 AM |
|
|
LEFT LOOKUP IN A ROW
I have rows of product data with monthly column headings. Each month, new
data is added. I already have the current month number, but need to extract
the previous month's number but can not use the monthly headings as a
reference. If I have the number "57" for Prod 3, from Nov. 08, what formula
can be used to find the number "12" also from Prod 3, from Oct. 08. Again, I
can not use the m...
|
6 |
12/21/2008 11:35:38 PM |
|
|
Copy Picture in Excel 2007
In Excel 2003, the Copy Picture function gave you the choice of 2 Formats:
Picture and Bitmap.
I need the Bitmap Format and can't seem to find it in Excel 2007. If it is
still there, where is it?
Respectfully submitted,
Bob Myers
...
|
6 |
12/21/2008 11:03:56 PM |
|
|
Date calcuation (another)
Widget A operates 24/7 until failure. The time is in 24 hr format. Need to
substract C2 from D2 to get E2 (same format). I've tried several functions
and examples from the Discussion Groups. However; I need to see the (a)
correct answer for validation -- I get confused easily...
A B C D E
01 Equip RunTim...
|
2 |
12/21/2008 10:06:40 PM |
|
|
IF Function
In each line of column A of spread sheet is day of the month in format
ddmmyyyy. I need that in column B appears 2ª for Monday, 3ª for Tuesday, 4ª
for Wednesday, 5ª for Thursday, 6ª for Friday, S for Saturday, D for Sunday
and H for Holiday. I tried with nasted IF and it works except for the
Holiday. Please assume month of December with Holidays at 1st December, 8th
December and 25t...
|
7 |
12/21/2008 5:30:18 PM |
|
|
how to spellnumbers?
hi.
please tell me the command how to spell numbers.
thanks...
|
3 |
12/21/2008 5:23:32 PM |
|
|
demerge mercge cells
I have a merge cell and would like to seperate them in to individual
cells.
I just wonder any functions to do so?
Your information is great appreciated,
...
|
6 |
12/21/2008 4:16:23 PM |
|
|
Including ADD-INS
Hi, there
I need to include the add-in that holds =NETWORKDAYS().
When running the installation process, although I mark the box for manually
chose settings, the update process runs to its end and does NOT allows me to
select add-ins.
Can anyone help, please.
--
Carlos Magalhães...
|
2 |
12/21/2008 12:31:01 PM |
|
|
Setting up an Excel sheet to automatically determine when an employee should enter a retirement plan, perhaps What-If Analysis would help? Any other suggestions?
Perhaps a What-If analysis would help with this, but the situation
that presents itself:
For retirement plans, usually a person must work one year of 1,000
hours before that person can enter into the retirement plan as a
participant. However, plans usually have set dates of entry, usually
twice during the year. Therefore, a person enters on one of those
entry dates subsequent to his attain...
|
1 |
12/21/2008 12:26:48 PM |
|
|
Sum with multiple criteria
I am looking for a formula to retreive the sum within a column with multiple
criteria.
I would like to be able to look totals for each day per shift.
Totals by day per shift would be great if possiable? I am struggling with a
formula that looks at date (A) and also a shift (B) and sum all of the cells
in (C) that have the correct shift by date.
Example:
column A column B colu...
|
7 |
12/21/2008 12:18:35 PM |
|
|
? How to enable functions that stopped computing after XP SP3 upda
-- example: WEEKNUM stopped working;
-- simple numeric calculations work; (calculate switched to 'auto'
-- YEAR function works (with the auto yellow syntax hint)
?? what gives ??
?? is there a function pack to reload or re-enable ??
Using: Excel 2003 (Office 2003)...
|
2 |
12/21/2008 12:04:00 PM |
|
|
sumif with multiple critera range and sum_range
Hello,
I have a worksheet where I'm trying to use the sumif function to sum over
multiple criteria ranges and multiple sum_ranges. The following formula,
which shows three ranges, (surprisingly) works. Is there a more compact way
to implement this? This is for a budget spreadsheet where each of the ranges
(J31:J36 for example, are one month. So the full scale formula would have 12
ran...
|
6 |
12/21/2008 6:54:17 AM |
|
|
how do I insert a blank row when a value changes, automatically
When I have a worksheet that is sorted on several columns, how can I set up
an action that will automatically insert a blank row between rows that have a
change to a given column's value, from the row just above.
Sample Value's
12
12
12
blank row
13
13
13
blank row
14
14
14
thank you
...
|
4 |
12/22/2008 11:43:01 AM |
|
|
Search / find Formula
Hi,
what is the formular that i can use to take one cell with data in it and
shearch/find that exact data throughout my workbook? The data will be entered
differently each time.
It is exactly like the 'find function' in your edit tab. but i want to put
it in my opening sheet.
thanks...
|
2 |
12/22/2008 3:22:02 PM |