copying a formula down wards
the above formula works in that it shows the first match.
As there could be mulitpule records what do I need to do to so when I copy
it down it will bring the next match or 0 if no further matches in the table
it is searching?
Try this ARRAY formula. ARRAY enter it and it will return the first match,
drag down for the second etc. It will return an error if there isn't a second
match so you could wrap the whole thing =isserror(formula etc
=OFFSET(IF(ROWS(B$7:B7)<=COUNTIF(Proj_code,$E$1),INDEX($F...windows search problem....
I have strange problem with windows search engine... i have 100000 txt
files and im looking for special phrase in few txt files i know that phrase
exist but windows search give me no information - can`t find. But on the
other computer on the same phrase and same files works good. I have
reinstall windows search ... but problem still exist... how can i resolve
regards - HE
...Sorting a column by using formula #3
I am trying to use sort function just to delete blank cells in between
Sort order doesn't matter actually.
Data is coming by the use of simple cell reference of "another sheet
Praise's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1558
View this thread: http://www.excelforum.com/showthread.php?threadid=27144
you may use the following addin to filter out blank cells:
&g...Formulae in headers or footers
Is it possible to put totals in a header or footer? I haven't seen any place
that says you can or can't. If you can, then how?
You need VBA code to do that. If your data is in D1:D100, this will do as an
Right-click the Excel LOGO near the file menu, select View Code, paste this
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.RightFooter = "Total = " &
> Is it possible to put totals in a header or f...use formula on external data range
I've got a problem with data I read from a database.
I wrote a VBA Sub in Excel 2007 with retrieves data via
ActiveSheet.QueryTables.Add() per OLEDB out of a database.
This works fine and puts the data in the range beginning on cell "A8"
Now my problem:
I have a formula '=SUM(A8:A10) in cell "B1".
This formula always comes out = 0, although there are values in the cells.
But if I edit cell "A8" without changing the value (just the alignment
changes) it is recognized and the formula shows = 1
What am I missing here ?
Thanks ...Using Invoice template: overriding formulae
I am having a problem when using the Excel 2000 Invoice template. Sometimes I
enter text into the 'Quantity' column. Then Excel is unable to calculate the
Total, in the blue shaded area.
My question is: How do I override the formula calculation in the shaded area
to simply enter the numbers and/or text of my choosing?
Evil flourishes when good men do nothing.
Don'y know how to override the original protectiion. Easiest would be to copy
and paste into new sheet and use this to create your own template.
> I a...Problem with DNS TTL on exchange and DC records
I am having a lot of problems with Exchange hanging on users and have
narrowed it down to the DNS TTL's being too low. On the e2k3 box I
have deselected the DNS auto register feature. I change the A record
on the DC and bump the TTL up to 7 days. But it keeps setting back to
20 mins which is way too low. I would also like to set the DC's to 1
day, but I am having the same problem. What am I missing?
On 8 Aug 2006 09:35:30 -0700, email@example.com wrote:
>I am having a lot of problems with Exchange hanging on users and have
>narrowed it down to the DNS TTL's being...Problem with Email Addresses in Our Domain
Exchange Server 2003. We just moved our entire organization's email from an
outside server to our own Exchange Server. We used to be able to send email
to recipients of the form "firstname.lastname@example.org" or
"email@example.com." Now when folks send to
@mail.goodnewsjail.org, their messages get stuck forever in the
"mail.goodnewsjail.org" queue. The queue never empties. What do I need to
do so that people can use either @goodnewsjail.org or @mail.goodnewsjail.org
on their recipient addresses? Thanks for the help.
Dr. Doug Prui...There is a problem communicating with the Microsoft CRM server
During the installation of the CRM Outlook Client I have a problem where I
cannot connect to the CRM server. I used the same address to connect CRM
Server via the web browser.
I then proceeded with the installation, hoping I could configure this after
I've completed the installation. I couldn't find anywhere how I could
configure the CRM Outlook client (Bit daft I thought or is it just me??)
When I fired up Outlook I got these messages:
"There is a problem communicating with the Microsoft CRM server. The server
might be unavailable. Try again later. If the problem...Problem with Exchange 2003 Permissions
I have a 2003 installation which only has one mailbox database and one
public folder database in the first storage group.
the issue im having is that i cannot mount the public folders db with
the error " The store could not be mounted because the active directory
information was not replicated yet you cant either... press cancel or
retry" and when I do a retry i got "The Microsoft exchange information
store service could not find the specified object." ID no: c1041722
I googled a lot about this issue which is supposed to be a permissions
issue but i had alre...Technical problems with the web enabled newsgroup?
Is anyone else having trouble accessing this Great Plains newsgroup through
the web browser interface? When I click on Great plains, sometimes it just
hangs. Sometimes Great Plains comes up, but doing a search will cause it to
hang. Logging into Passport before going to the web site doesn't seem to
make any improvement.
I have had go back to using Outlook Express.
...C# Keyboard Hook Problems
I'm trying to implement a keyboard hook that will receive all keyboard
events within my application, and only my application, using C# .NET
3.5 and VS 2008.
I'm using the following code:
private delegate IntPtr KeyboardHookCallback(int nCode, IntPtr wParam,
private static KeyboardHookCallback _callback = new
private const int WH_KEYBOARD_LL = 13;
private static IntPtr SetHook()
return SetWindowsHookEx(WH_KEYBOARD_LL, _callback, IntPtr.Zero,
[DllImport("...Connection problem between publisher and outlook (2003)
I've created a newsletter in publisher. I've clicked on send e-mail, then
send this page as message. I get a messgae saying 'Publisher could not start
the email program. Check network connection, etc' Outlokk is my email program
and is up and running, there are no internet problems and other programs work
I've tried detect and repair and also reinstalled office.
Any other suggestions?
Just checking - which version of Publisher?
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"exmt...outlook log in problem
i have installed office pro 2003 and defaulted my mail to outlook from
outlook express. all data for mail accounts has been transfered like for like
but when trying to send/recieve mail a log on pop-up requesting verification
of user name and password appears. it then rejects these as unrecognised. all
mail that has passed through o/express is showing. i ahve double checked my
settings also deleted the settings and reinstalled them and deleted all
settings at o/express and reinstalled them to no avail. and if i go back to
o/express everything works fine???
> i have in...Resolving "Bounce" Problem
My customer has been placed on SpamCop's list for a second time due to
"Excessive Bounces". I am already diverting bad e-mail to the Exchange 2003
BADMAIL folder. And, I continue to get a variety of 5.x.x event entries.
While our DNS is a little complicated (e-mail is initially directed to TM's
VirusWall and then forwarded to Exchange 2003), I don't see any issues with
our DNS entries. Why are we getting "Excessive Bounces"?
On Tue, 17 Jan 2006 15:56:02 -0800, GDA
>My cust...text formatting problems
I receive spreadsheets from remote site support staff containing Ethernet
addresses in a column. Often these are entered with spaces, hyphens, etc.
between each pair. However, I need them to be 12 character strings, no spaces
or other chars. The column is formatted as text, and I do a replace on the
problem character. This works unless the address could be interpreted as an
exponent; i.e 00-50-04-82-1E-20 becomes 5.00E+26 when I replace the hyphens
with nothing. In addresses that do not contain alpha chars, the leading zeros
Has anyone else seen this? How do you get aroun...2003 pop up "encountered a problem"
Pop up "Microsoft Outlook has encountered a problem and needs to close"
appears often. Outlook then must be closed and start again. What is this
and how can I correct it.
...Formula to Get the Max of a column and its definition
Let's say I have two columns...
Column Z = Product Name
Column B = Reject Quantity
Problem: Using Sheet2, How can I have the Max value of the Column
(from Sheet1) and have its Product Name from Column Z? Remember, th
Sheet1 table is modified every now and then so the max value of B migh
be different in every minute.
Desired End Result:
Reject Quantity Product Name
Please help me on this....
Shadow_Otixz's Pr...Outlook 2003 Synchronization Problems
Our company just upgraded our email server from exchange 2003 to the exchange
2007 a couple of weeks ago. Everything was Ok until yesterday. I am having
a problem with only two computers using outlook 2003. The problem happens
when we are inside our own LAN. There are two Synchronization errors I am
getting and they are:
9:18:41 Synchronizer Version 11.0.8000
9:18:41 Synchronizing Mailbox 'User Name'
9:18:41 Synchronizing Hierarchy
9:18:41 Microsoft Exchange offline address book
Task 'Microsoft E...No Edge Server No Problem?
We are using an Ironmail appliance as a smarthost attached to our mail server
that is functioning as all roles except the edge server. I'm trying to route
mail out through the ironmail appliance but it does not seem to be working.
There should not an issue routing mail out through the Ironmail appliance
instead of an Edge server is there?
Nope, Edge isn't required. You might want to detail what is happening, what
errors, can you manually telnet to the Ironmail appliance, etc, etc.
"D303M"...GP 9 BR, problem setting up named printer
Perhaps I'm not doing something correctly...what I want to do is allow the
users to select whatever printer they want. Some of them use local printers
for checks, but I need to allow them to print reports to one or more of the
It appears I have to set a printer for System and Company before I can set
anything else to Manual. If I do this for anyone who isn't an administrator,
when they attempt to log in to GP (even on my PC as well as theirs, on which
I tested a users' login), they receive "You don't have security privileges to
open this w...Help to modify a formula
This is my formula I need help with,
in cell I10 this is entered
Problem is when cell I6 & I7 are blank cell I10 shows #value I need it to be
blank or 0
You should be getting zero when I6 and I7 are empty. It sounds as if there's a space or
something like that in the cell. Some folks do that to clear a cell.
Regards from Virginia Beach,
"Bob Bob" <NOeMAILl@mail.com> wrote in me...Recurring Booking Resource Problem
When I book a meeting with a resource in recurring, I get an error:
"Resource has declined your meeting because it is recurring"
I thought it was a bug with my Exchange 2000 Server or my Office 2000. So, I
just waited until...
I upgraded my Exchange 2000 to Exchange 2003, and I upgrade my Office 2000
to Office 2003.
But, the problem still exists.
Any idea would appreciated.
YOu need to check the config file of the autoaccept agent. THere is an
option to refuse recurring appointments
"Ross" <firstname.lastname@example.org> wrote in message
news:7K2dnRGK8Yekd9...Weird problem with Publisher's listing of available printers #2
None of the installed printers will show up in Publisher on this lady's
computer. They are installed in Windows and show up fine in other Office
Programs (Word, Excel, Powerpoint, etc.). However, when you go to print
a document in Publisher, the only printers listed are the "Microsoft
Office Document Image Writer" and the "Lanfax Printer". None of the
physical printers are listed!
I tried uninstalling and reinstalling all the printers. I also tried
upgrading from Publisher XP to Publisher 2003, but the problem has
persisted. I have googled this and searched Micr...Problem wiih declared index in xml
In Access 2003, I exported a table in a file.XML, with shema (and with
primary keys ans index informations) and data.
One of the rules on indexes is that field 'Name' & 'First Name' must be
And I can see that is defined in the shema of the .xml file.
Now, I read this file when opening a form in VS2005 with this code :
Dim dt As New DataSet
Me.DataGridView1.DataSource = dt.Tables("obj")
So, I see data in the DataGridView, and it ...