Help with a formula please.
In column "A" I have about 400 file names with each path, for example:
Each file contains a value named "ATT" and another named "XBB". I need to
get these values in adjoining columns. I've tried every variation of the
following I can think of without success:
None have worked. I'm sure I have done this before but can't remember and
can't find any of my old files with an example.
More like: A1&"!ATT"
"jim...Excel Progrom Error
Happy new year to all.
I often receive the folowing error message in a box titled "Program
EXCEL.exe has generated errors and will be closed by Windows. You will
need to restart the program.
An error log is being created.
The only option is OK which closes Excel. I do not know where the
error log is created.
I am using Office 2000 Service Pack 3 with Windows 2000 Professsional
Service Pack 4.
Can anybody throw some light on this error.
Thanks in anticipation.
What are you doing at the time (i.e. is it consistent)?
----------------...Sharebuilder account import error
Invalid .qif header error when trying to import .qif file from sharebuilder
Anyone know of a fix or experienced this problem??
I typed a long mail to sharebuilder regarding this issue...still waiting
fora reply. Hopefully they will be able to help. Microsoft flat out told me
it wasn't their issue and to contact my broker! No help AT ALL.
...Storing Data in Microsoft Excel
Hi I wonder if anyone out there would help I have excel, and I have some
data which I update daily in the spreadsheet, I would like to create a
macro, to copy all the data onto another page, and then, so that the next
day I enter new set of data and when I press the same button it copies it
all to the same page as the other data, but one row underneath (so that it
doesn't override it)
I know this can be done, but I cant remember how to do it. I did something
in VB, active.offset but that's all I can remember if there is anyone that
could help that would be brilliant
All the be...Need help w/ excel formula (duplicate entry)
I am not sure if this is possible but I would like
write a formula that would recognize a duplicate entry
under same column.
e.g., column A has heading of Sample ID# and
under is sample ID# in random order. If an entry
of ID is then made but if it is a repeat of the ID that was
previously entered, I would like to it to give some kind
of warning message.
You may want to read some of Chip Pearson's techniques for dealing with
Visit Chip Pearson's site for a Data|validation solution:
http://www.cpearson.com/ex...The amount on account can't be less than zero
A return was done with a cash payment. It appears a discount was given after
the 'amount received' was entered. So we have a posted document with a
document amount lower than the 'amount received'. There is a negative amount
'on account'. How can this be fixed?
I did a return but it will not accept a value 'on account' which is less
than zero. How can this be fixed.
wouldn't you want to do a credit note to the custoer account to bring the
> A return was done with a cash payment. It appears a discou...I need to widen my screen so I can print a wide file?
How do I do this?
I need to print a copy that shows all the script which is too wide.
I'm not sure what you are trying to do, but changing to Landscape orientation
might help. Assuming that you are using Word 2007, click the Page Layout tab,
and then click Orientation in the Page Setup group.
Microsoft Word MVP
"bingo" <email@example.com> wrote in message
> How do I do this?
> I need to print a copy that shows all the script which is too wide.
...DPM2010 RC Errors on secondary server.
We have recently upraded our 2007 SP1 Primary DPM server to 2010 RC and it is
I've set up a brand new, fresh Windows 2008 R2 Server for the secondary
server, and have told it to protect one of the protection groups on the
Everything works for a little while, but every half hour or so, the DPM
service crashes and says:
"Connection to the DPM service has been lost.
Review the application event log for information about a possible service
Then asks to restart the administrator console. This kills the ...Help with Formula Please
I have the following formula in cell c1 in a spreadsheet:
200 over - 195
200 over + 205
200 under FALSE 205
200 under + 195
What I've done above is test the formula for all four possible
outcomes. As you can see the third outcome in the table (the fourth
argument in the formula) is false, but I want it to read "-".
I have changed the formula around every way I can thi...Problems with Using Query with Analyze it with Microsoft Excel
We have a problem with Access 2003 and EXCEL 2003. I have a QUERY from
ACCESS 2003 and hit the following sequence of commands - "TOOLS" "OFFICE
LINKS" and "ANALYZE IT WITH MICROSOFT EXCEL". I notice the Excel pops up
and I see fields being imported and when it is down the Excel spreadsheet
is blank - not even a blank spreadsheet comes up. What am I doing wrong.
We need Access 2003 to link to the data in Excel so we can edit and modify
it using EXCEL as well as ACCESS.
Thanks for your help.
I am using a spreadsheet in Excel 2002 on Windows XP, for some reason the
account numbers (which someone input, along with addresses) have a little
green mark in the corner of the cell. I thought it was to show that there is
a comment, but it is not. When you click on the cell, a little warning sign
shows, saying ERROR - number in this cell formatted as text or preceded by an
apostrophe. When I click on the arrow by the warning sign, it says
Number stored as text
Convert to number
Edit in formula bar
Error checking options
Show formula in audinting toolbar
Now I looked a...error, chkdsk
Questio, when I try to open excel or winmx, an error pops
up saying chkdsk, so i ran a chkdsk and it doesnt do
anything. The error also says corrupted file. In excel I
have some important work that I need to open, and it only
opens in Turkish, if I change it to English, its a bunch
of boxes and letters, its not my work I need. How do I
change it back.
What excel version are you using? Try to find somebody with 2003
to see if they can open the file. Otherwise you would look for
some commercial software that might be of help
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B30...count results of formula, not text in formula
I would like to count the results of a formula, format is a mix of numbers and text.
A B Formula in Column B is
1 8 (8),(7) ="("&A1&"),("&A3&")"
2 10 (10) =+A2, with custom formatting of (0) to show brackets
3 7 (8),(10) ="("&A1&"),("&A2&")"
There are numbers in Column A in rows 1 to 5, there are formulas in
Column B. The actual formulas are the column I need to count the
requirements. In this example, I need to count ...when receiving pics, how can i have it that i scroll down and see
I use Microsoft Outlook 2003. When I receive pictures in an email, I have to
open each picture individually. Other people I know can just scroll down in
their email to display the pictures. How do I do that?
Outlook EXPRESS allows you to view pictures inline. Only if the sender =
embeds the pictures in a RTF or HTML formatted message will you be able =
to see them without opening each one. Outlook does not display images =
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account w...4.4.7 error
I have problems on one client that they don't recieve all emails from people
sending to them. I guess something is wrong in the configuration. When I do a
nslookup -type=mx domain.com I just get unautharized answer. Also the ttl
time is just 1800 when I do a dns report. Do the guys that handle the dns
The people that doesn't get their mail throw get the 4.4.7 error in return.
Ed Crowley MVP
"There are seldom good technological solutions to behavioral problems."
I am receiving the following error messages, please assist
Could result be sent to firstname.lastname@example.org
Your server has unexpectedly terminated the connection. Possible causes for
this include server problems, network problems, or a long period of
inactivity. Subject 'brocolli & mushroom stir fry noodle', Account:
'pop.gmail.com', Server: 'smtp.gmail.com', Protocol: SMTP, Port: 995,
Secure(SSL): Yes, Error Number: 0x800CCC0F
Your server has unexpectedly terminated the connection. Possible causes for
this include server p...Excel error codes translations
Does anybody know where I can find a kind of dictionary for Exce
The problem is sometimes I get an error message that is not in Englis
and without error code and then looking for the solution I must kno
its equivalent in English.
Message posted from http://www.ExcelForum.com
...delete server...routing master error
I have 2 exchange servers (exch 2003) and i have to delete
one of them.
I changed all replication etc...(before we had also a 5.5
which is already removed) but when i stop the services and
try to remove the server via system manager of my second
exchange (the one that will stay) i get an error message
that my server that i want to delete is the routing master
for that group.
How can i make my other server the routing master ?
i don't have any site replication (deleted it because not
Go to routing groups > first routing group > mem...need help coming up with a formula.
I know just enough in Excel that I know I can get the info I want but
not enough to know how to do it. Any help would be much appreciated. I
am working with 2 columns of data, for example:
Days in Stock____________Cost
What I want to calculate is the average cost for 0-10 days in stock
(($300 + $400)/2= $350), the average cost for 11-60 days in stock, and
the average cost for 60+ days in stock.
What sort of formula would best cal...toolbar, date, services, errors, paste, minimized system restore doesn't work
I have a XP system that the toolbar does not show open programs, services do
not seem to load at boot, the date is off by one month, I cannot paste
anything that I copy, and system restore does not work. All of these issues
started at the same time a few days ago. Has anyone else seen this group of
errors? I am trying to resolve and do not know if it is a system update
gone bad, or if maybe it is a viruse/malware issue. Please let me know if
you had had these problems together and what you did to fix them.
There is a very good chance that you are seeing the effects of a hi...formulas #10
Can someone please help me with these 2 formulas that I need to enter into
my Spreadsheet?. I am trying to set up a Profit calculator for my Ebay
listings. This would be appreciated
thanks so much
Selling Price - US$25.01 - US$100.00
10.00% of the initial US$25.00 (US$2.50), plus 7.00% of the remaining
closing value balance
Selling Price - US$100.01 - US$1,000.00
10.00% of the initial US$25.00 (US$2.50), plus 7.00% of the initial
US$25.01 - US$100.00 (US$5.25), plus 5.00% of the remaining closing value
balance US$100.01 - US$1,000.00
On Feb 7, 11:36 am, "Bacchus" &l...Can you link many workbooks to one template? And Update?
I tack around 100 different workbooks. All are the same "template"; however,
I often update the formulas and therefore must go back to each workbook and
update them formulas. Is there a way to link all of the workbooks to a
"template" to calculate the formulas? And can I change the one template
formula so all the workbooks are updated at once?
...Re: Money 2004
Thanks for the suggestion. I tried unregistering/re-registering the msxml3
DLL, but still no luck. However, knowing the help file topics are local
might help with debugging this problem.
"Randy" <email@example.com> wrote in message news:...
> I've recently upgraded to Money 2004 Premium from 2003 Deluxe. I'm now
> finding that I can't view any help topics--I get the "Unable to load
> Click here to try again." I've tried all the suggestions posted here and
> other sites: cleared out temporary in...set up different default printer for MS Excel
I have a printer A set up as default for my PC. I want to have a printer B to
be default one for ALL NEW Excel files. So task is not to change it manually
or via some macro button; the task is to have the printer B ready directly
after opening of Excel file. Any suggestions?
You can change the default printer for all applications with the Windows Control Panel.
Start - Control Panel - Printers and Faxes. Right-click the printer you wish to be the
default, and choose "Set as Default."
To set a default printer for Excel only (different from the Windows default printer...About Fixed Asset Management
Might I ask some questions about Fixed Asset Management?
1. While I select the currency ID (not functional currency), an error
message is prompted with the following information.
The Rate Type ID isns associated with Currency ID "XYZ"
Message Number: 30910071
But I can use that XYZ in payable transactions.
What should I do if I want to correct this mistake and use the
2. I have selected "POST PM to FA". After I post payables transaction using
FA accounts in PURCHASE type, I can't find the purchase button appear in
Asset General Informat...