Match and lookup data #2
I would like to look up data in another sheet of the same workbook onl
when it matches data selected in a dropdown(s).
Attached is a spreadsheet which better explains my predicament
I tried the various lookup and match functions and even tried combinin
them but my not so superior knowledge of Excel limits me.
Please help guys
Attachment filename: timesheet test 1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56973
Message posted from http://www.ExcelForum.com
...NO DEFAULT SMTP SERVER..
I had a problem with exadmin.dll, unregistered it, copied
new one and registered it and now the default smtp server
is gone under SMTP in my systems manager but everything
HELP where is it ? and how can i get it back ?
...colour coded points depending on error amount
Hi i'm using excel 2007 (SP1) just wondering is there a way to automatically
assign a different colour to points depending on the difference between the
results on both axises?
The data i'm using is a set of elevations from two different sources that
show the error in an elevation model. I need to ideally make points that say
have a differnce of <50cm from perfect corelation appear a differnt colour to
those which are for example <25cm.
can this be done? any help would be awesome!
I've uploaded the file if anyone wants to take a look:
http://www.filefactory.com/file/...Upgrading from server 2000 to server 2008R2?
We would like to upgrade our servers to Windows server 2008 R2. Currently
we have two Windows 2000 (SP 4) domain controllers, we want to replace the
Forest Root Domain box with new hardware & upgrade the other DC to server
I understand it's not possible to upgrade from 2000 straight to 2008 but is
server 2003 still available to ugrade to in between? I'm also not sure of
what the implications of retiring the Forest Root Domain box would be?
Would the best plan be to add the new 2008 server (domain function & forest
function level: 2000); upgrade the se...Can Recovery Storage Groups be used if original server gone?
We had an Exchange server die on us a few months back due to hardware issues.
All accounts were moved to another box and that one was flattened and taken
out of the Exchange org. It was replaced by new hardware that does NOT have
the storage groups or databases that the old one did.
We have a request to recover data from an info store back up prior to the
events above and are running into problems with our backup vendor. Would it
be possible to use a Recovery Storage Group to retrieve this data? The
mailbox still exists (but may have been moved via Exmerge) so I believe I
will pas...MS Project Server Admin // Denver, CO
MS Project Server Admin
Location: Denver, CO
Duration: 6 months
Pay Rate: DOE
=95 MSProject Server ver 2010, SQL database and Sharepoint 2010 =95
Ongoing support and maintenance involving activities such as =96
Monitoring logs, Patches, resolving support tickets, Dev/Test/Prod
support =95 Routine troubleshooting =95 Technical APS maintenance (Project
Server & SharePoint 2010) =95 User administration / Password resets etc.
=95 Work with Microsoft for any critical issues that might need
intervention from Microsoft =95 Application of Patches & migration to
Production =95 SQL services mo...Publisher 97 unable to do Mail Merge
I can't find my post with the above title in this forum, only in archives
I'm using XP.
Mary Sauer said she couldn't get Mail Merge to work in Pub 97 or Pub 98 . .
.. Re-registered all the .dll's . . . Assumed it was a security update that
did them in . . . using Vista on this machine, but it's the same on her XP.
I just came across this article: 1/15/09 Microsoft beta lets old Windows
apps run on Vista
http://www.infoworld.com/archives/emailPrint.jsp?R=...Small Business Server in Windows Server 2000 Environment
I have a requirement to install Microsoft CRM for about 10 CRM Users. The
existing Windows 2000 has about 120 users with two Exchange Servers. Is it
possible to set up a separate Small Business Server to run CRM within the
Windows 2000 domain as this is the most cost effective way of implementing
CRM for such a low User count?
...Event id 467 and error 1018
Event is with 467 is logged in event viewer having message "storage group
databse priv1.edb : index MsgFolderIndexURL CompNamePostfix table 1-6e6d is
corrupted" and online defragmentation is stop in between with error -1018
event id 705.
We have exchange 2003 sp2 and i am new to exchange.
what is the best to do in this situation.
I am going to do offline defragmentaion on our exchange databse using
eseutil /g and /d parameters.
Is that ok or any other solution of thid database corruption.
if you have better suggestions tell me please.
On Fri, 17...Question #2
Is there a way to use the sumif function in regards to a
cell's format? For example, I want to sum all cells that
are filled in red.
Try a visit to Chip Pearson's site for this issue:
Here's an extract that covers what you want:
The following function will return the sum of cells in a range that
have either an Interior (background) or Font of a specified color.
InRange is the range of cells to examine, WhatColorIndex is the
ColorIndex value to count, and OfText indicates whether to return ...Removed server, exchange still looking for it?
Exchange 5.5, I removed a server from the site using exchange admin, and now
am getting event 9318, saying MTA can't contact it. Why is it doing that?
I had the same problem after a 5.5 to 2000 migration. Rebooting the
Exchange server that was trying to connect resolved the problem.
MTA must keep the information cached.
"dlw" <firstname.lastname@example.org> wrote in message
> Exchange 5.5, I removed a server from the site using exchange admin, and
> am getting event 9318, saying MTA can...windows 2008 server cord and windows 2008 std
we have 20+ New server to install windows 2008 for trading purpose.
still can not decide to install server core or std full, can someone advise
what is the benefit to install core rather than std edition or to install std
Server Standard Core
Server Enterprise Core
Core is (not quite correctly called) 'Server without Graphical User
There are several reasons why Core was introduced:
- *Nix purists were saying that there's no real need/use for GUI on a server
and *real* sysadmins ar...Outlook 2000 experience error outlook must shut down
I just recently configured my outlook to allow contacts
to be shared thru net folders. when doing so outlook
requires addition software to be installed which it
automatically loaded. Ever since I made this change one
of the three commputers on the network continues to
receive error mesage while outlook is
running "Experiencing error Outlook must shut down"
App Name: Outlook.exe
App Ver: 188.8.131.5204
Mod name: fldpub.dll
Mod ver: 9.0.3425.0
I've restored the system back to the original
configuration and outlook runs fine.
...faq how to disable link error message
When I compile my prject this displayed :
warning LNK4017: DESCRIPTION statement not supported for the target
so I want to use #pragma warning (disable : 4017) to disabled the message
display again, but I failed. How to do that?
Another , what is different between put the
#pragma warning (disable : 4017)
at the top of the *.cpp and the bottom of the *.cpp?
Thanks a lot.
...Sorting Data #2
I have informations for transactions:
C1:C10 = Costs
There are rows that contain no data. Examle:
rows 1.3.4,9 may have data
rows 2,5,6,7,8,10 would be empty
I'd like to sort the data to elimated the empty rows at the following
locations and show 4 consecutive rows of data. :
A12:A22= sorted dates
B12:B22= Sorted names
C12:C22= Sorted costs
Any help is appreciated, Thanks
travelersway's Profile: http://www.excelforum.com/member.php?action=getinfo&...Outlook won't leave messages on the server
I have tried and tried to keep Outlook 2003 from deleting
my email off my server. I have found the check box under
advanced send\receive setting in "options" and I have
tried variations of the 3 check boxes in this window and
they work until I close Outlook and reopen it, then all
of my settings return to the default of deleting my email
off the server.
Wasn't MS suppose to stop doing things like this? Any
help in steering me to the answer (which i am sure is
here) to this question is appreciated.
Paul A. Walters
Goto Tools --> Email Accounts --> V...Application error for documents containing field codes
I use field codes extensively. The same field will have to be displayed in
either all uppercase, title case or lower case throughout the document. When
I add the filter to change case, the correct value is returned in the
document. However, when I try to do this with an autocorrect into a blank
document, I instantly get the "Microsoft has to close." Then I have to
recover the document and expand the autocorrect a second time. It will allow
the expansion the second time, but never the first time. This happens like
clockwork. I have sent about 19,000 error reports to...Sales for Outlook 1.2 Client Install Errors
We have been experiencing some problems reinstalling the
Outlook Sales client on a machine that lost functionality
with the CRM Appointment button. The form just stopped
loading when the button was clicked, so we followed the
1. We removed and then re-added the COM object Microsoft
CRM Outlook Addin and also cleared the forms cache in
Forms Manager. This did not resolve the issue.
2. We then completely uninstalled Sales for Outlook 1.2,
rebooted the system, reinstalled and rebooted and when
Outlook was launched, it now delivers the error "An error
occurred in...Smart Pointers and compile error
Hello - was just switching some of my old style com calls to Smart Points when I compile now I get a
C:\Program Files\Microsoft Visual Studio\VC98\INCLUDE\comip.h(662) : error C2247: 'Release' not accessible because 'IDispatch' uses 'public' to inherit from 'IUnknown
error. Downloaded SP6 and that didn't seem to help - Any ideas ?
...Project Server Provisioned
Hello, I have provisioned Project Server and added it to the trusted
zone, but it still comes up unresolved.
You mean PWA home page is not loading or issue with connecting from MS
Also mention the version of Project Server.
On Apr 16, 11:04=A0am, me <mtyso...@yahoo.com> wrote:
> Hello, I have provisioned Project Server and added it to the trusted
> zone, but it still comes up unresolved.
On Apr 16, 12:20=A0pm, Chak <chak...@hotmail.com>...Error -2147211802
Using Vista and RMS 2.0.0126 - go into SOA and try to delete Database and
get the following error:
Erorr - 2147217802: Cannot drop database 'SSS' because it is currently in
I have a single license RMS system and nobody else is on the system. Tried
rebooting the system, reindexed the Database, DBCC the database - no errors.
Any help would be appreciated.
Try to stop service and restart it. Then try drop it. or use the following
script is SOA
DROP DATABASE "database_name"
"Dan-902" <email@example.com> wrote in message
news:Ox...OT: SVN server
Sorry for the OT, I am not 100% sure where to ask.
I want to setup a subversion repo on a personal website.
Would anyone know the best forum/NG to ask such a question?
(Or where I could find a tutorial for installing such a repo).
> Sorry for the OT, I am not 100% sure where to ask.
> I want to setup a subversion repo on a personal website.
> Would anyone know the best forum/NG to ask such a question?
> (Or where I could find a tutorial for installing such a repo).
...Outllook 2000 Error
Anyone have any experience with the following error:
OUTLOOK caused an invalid page fault in Module
I've tried running the "Repair Office" and it seems to
clear up for a bit them comes back.
...Windows Server 2008 RC2 in Windows Server 2003 Domain
I'm having trouble with one domain controller that has all of the FSMO roles
(I have 6 Domain controllers in total running server 2003) I updated my
schema to version 47 (Windows server 2008 RC2) and would like to add a new
physical server with W2K8 R2 on it and transfer all of the FSMO roles on it.
I don't want to upgrade all DC's yet to 2008 R2 yet, so the domain
functional level will stay the same for a while (Windows Server 2003). Is
there anything I should watch out for with this scenario? Or by just adding
a W2k8 R2 box with all the FSMO roles and then decomm...Worksheet names #2
Is there anyway to name a worksheet with text from a cell in anothe
Message posted from http://www.ExcelForum.com
only with VBA. using something like
dim wks as worksheet
dim target_wks as worksheet
set wks = activesheet
set target_wks = worksheets(1)
> Is there anyway to name a worksheet with text from a cell in another
> Message posted from http://www.ExcelForum.com/
Thank you this helped a lo
Message posted f...