Lookup based on criteria in 2 columns
I am trying to use a vlookup or other function to return the value in the
amount column based on the location and date. Here is a sample of my data:
Location Date Amount
101 9/15/8 10
101 9/16/8 20
101 9/17/8 15
102 9/15/8 50
102 9/16/8 75
102 9/17/8 67
For example if I wanted to return the amount for location 102 on 9/15/8,
what formula would I use? I tried using variations of vlookups but had no
Peo Sjo...Microsoft POS #2
I have a group of customers that I am working on setting up A bundled POS
I have looked at RMS and Microsoft POS. The customer's are small bulk food
stores. They package all of the bulk food in various containers and weigh it
with a Hobart scale producing a label with an system 2 price enbedded
barcode. These are UPC A formats. They are for the most part simple single
store installs and donot require the complex RMS system.
I have setup the Microsoft POS version 2.0 and found it will work perfect
for these customers. The only problem when you programed the system you
l...Outlook 2003 keeps crashing #2
I get this message when I look in System information. Outlook keeps
crashing quite often. I cannot for example delete two messages without
outlook crashing. My colleagues do not have this problem. We are using
the Microsoft mail exhange server.
Faulting application outlook.exe, version 11.0.5510.0, stamp 3f1380f0,
faulting module mso.dll, version 11.0.5606.0, stamp 3f334cce, debug? 0,
fault address 0x003b6e16.
Does anyone has a solution?=20
1) I would definitely apply Service Pack 2for Office 2003 + applicable
critical security updates.
2) Have you tried starting O...Using expression builder object
I'm developing a wizzard in Access which builds import templates for various
data sources to a fixed set of tables. In step 3 the users must be able to
build an expression ; for instance Left([Fieldx],20) . Now I would like to
have a command button on my form which calls the Access expression builder to
allow the users to use this to build the expression. This expression will
then be stored in a text box linked to the templates table.
Anybody know how to call and use this object from VBA code?
I th...Rollup 2 and Office 2007
I already have Roll Up 1 and the Office 2007 compatibility patch installed.
If I now install roll up 2 will I have to reinstall the office 2007
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. firstname.lastname@example.org
> I already have Roll Up 1 and the Office 2007 compatibility patch installed.
> If I now install roll up 2 will I have to reinstall the office 2007
...Using part of a cell in a chart title
I have a chart which should get a title. However, this should be partly be
used from a cell e.g.
"counted with 5%"
5% should be taken from the cell and used in the title.
Is this possible?
Yes it's possible but all of the chart title needs to be in the cell. So you
may need to use a helper cell and concatenate text and value.
Andy Pope, Microsoft MVP - Excel
"Nicole" <Nicole@discussions.microsoft.com> wrote in message
news:5CB7A971-AA7F-4C34-BB42-7DC283AA2958@micro...copy my vb project... is it as easy as copying the directory..
I want to take a copy of a project so I have two projects the same.. the
idea is i can play around with one, and not effect the original..
is it as easy as just using file explorer to copy the directory from say
c:\project1 to c:\project2... or do the project files like forms etc have
paths in them and therefore I can't just copy like this..
"AussieRules" <email@example.com> wrote in message
> I want to take a copy of a project so I have two projects the same.. the
> i...Copy entire row where CellValue=0
I need to loop through the collumn and search for value that is more then 0.
When I find it I need to copy whole row and paste it 2-3 rows below the
table. I tried to select the collumn and search the selection but for some
reason I copy and paste only one row.
Thank you for any help.
as a starting point:
"OxanaB" <OxanaB@discussions.microsoft.com> schrieb im Newsbeitrag
> I need to loop through the collumn and search for value tha...How do I use traffic lights in excel
I am wanting to use traffic lights in excel that change colour based on the
result of a variance cell, ie if the result of the cell is 10 make the
traffic light green, if it is 20 make the traffic light amber, if the result
is 30 make the traffic light red. How do I do this?
Format>Conditional Formatting>Cell Value is:
Note: you can add up to 3 conditions(4 if you count default)
Gord Dibben Excel MVP
On Wed, 22 Dec 2004 16:35:03 -0800, Shorty <Shorty@discussions.microsoft.com>
>I am wanting to use traffic lights in excel that change colour based on the
&g...Filter recordset using query results
I have a form based on a query called [qry Quarterly Planning], it lists all
Itineraries on the system. On this form you can filter records by specifying
a Start and End Date for the [ReviewDate] and/or [Specialist]. It is a
subform on a main unbound form, lets call this Subform1. Along side this I
have another subform (Subform2) which displays ReviewDates that exist
against an Itinerary. In other words Subform1 has a start date of an
activity and if the activity lasts longer than 1 day, then the additional
dates are stored in Subform2 (ItineraryDates). Currently when I...Please ignore #2
Testing a posting problem
...Outlook freezes after sending one email after upgrading 4.0
We just upgraded from 3.0 to 4.0 this weekend. All client machines have had
the desktop client upgraded and 2 have the same issue. One is XP with Outlook
2003 and the other is Vista with Outlook 2007. Open opens and the CRM addin
initializes correctly. As soon as you compose and send an email, Outlook
locks up and you have to kill the process in task manager to close Outlook.
I've had the same problem and have tried all I can think of...how did you fix
> We just upgraded from 3.0 to 4.0 this weekend. All client machines have...2 register ruinning together on one z report
Is this possible, to have two registers running on one z report ?
We have a small store and would like to setup a second register as a backup,
temporary addition ( during rush hours)
Since we are a small show i do not need to have a separate register reports.
Can two registers ring up all sales together as one ?
How can i set this up ?
No, you can't do that.
You might be able to use the Register Analysis report available in SO
Manager Utilities/Crystal Reports to get something close to a single Z
Tiber Creek Consulting
firstname.lastname@example.org...Using Visio HTML output within frames
I want to include visio HTML output in a frame of another html file.
Unfortunately it is not working.
I understood the problem is in vml_*.htm files. It is due to, the
target arrtibute(pointing to _parent) in v:shapetype tag and
href attribute (pointing to #) in v:shape tag. These attributes should
point to "_top" and "<target-html-file>#" respectively inorder to work.
I want to change these options while saving .vsd as web page?
I would appreciate if you can help me in this regard.
coor...Upgrade CRM 4.0 Professional to CRM 4.0 Enterprise
When I enter the CRM license code in the Deployment Manager to upgrade to
Enterprise I get a message "The license code entered is not valid for
upgrade. Make sure you have entered the license code correctly, and then try
again". Do I have to reinstall CRM 4 to install Enterprise?
what is your current installation? Professional?
Have you entered trial version license keys ?
Current is Professional. I got the key from our MSDN subscription which
didn't indicate a trial license. I was able to install the Enterprise edition
on a test server using the same key w...Newbie Question: Using Web Services
I've been trying to implement Infopath with CRM with no success. I've
tried the example, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmbscrm1_2/html/mbs_crminfopathcrmintegration.asp,
to no avail. I have followed the example to the letter, but find the
information about publishing the Web Service to the server to be
somewhat lacking. Admittedly, I am not a programmer, and I am
continually running into an error in line 54:
Has anyone else ...matching contents #2
E1 thru E10 contains sequentially-sorted data. B1 thru B6 contains
sequentially-sorted data which matches SOME (but not ALL) of the data
in Col A. For example.
1 1 1
2 3 2
3 4 3
4 5 4
5 6 5
6 10 6
I need to move the data in the cells in Col B next to the cells in
Col E that have the same contents. For example:
1 1 1
3 3 3
4 4 4
5 5 5
6 6 6
10 10 10
Besides dr...Outlook Express 5 #2
On loading, error message "MSIMN caused an invalid page
fault in module DIRECTDB.dll at 017f:7dbf3070.." Appeared
to coincide with display config change?
Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum.
Outlook Express is family of Internet Explorer and Outlook of the Office
Here is the link for the right forum
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tip of...Workbook_Open Help #2
Here's the code
Private Sub Workbook_Open()
Call Unhide_Sheets '
Fable's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=218
View this thread: http://www.excelforum.com/showthread.php?threadid=26252
and there's no application.screenupdating=false statement in your
"Fable" <Fable.1d07w...CRM 1.2 12-02-05
I have installed MS CRM 1.2 on a SBS 2003 server. Problem is I can only start
the application if I log onto the server usind the server administrator
account. If I try to access using a domain users account I just get a page
cannot be displayed error, could somebody please help...
Have you added the appropriate domain users as crm users using the
"Redders" <Redders@discussions.microsoft.com> wrote in message
> I have installed MS CRM 1.2 on a SBS 2003 server. Problem is I can only
>...Does CRM have a Microsoft Project like add-on?
Does anyone know if CRM has a Microsoft Project like add-on?
I was using Microsoft "Project Central" (which had it's own issues), but am
looking for something like that. The best of both worlds would be an
interface between the two packages.
I am open to any suggestions.
Project Central (v2000) was the first attempt to take MS Project to a
server-based centralized solution. They have made great strides in more
recent version. The latest is called "Project Server 2003" which is part of
the "Enterprise Project Management Solution&q...reason codes #2
I'm having a big problem tracking discounts in RMS. Whenever something is
discounted up front, a reason code is set. There are several I use for
However, when I try to do an Item Movement History report and select based
on those reason codes, I never get any matches. When I do an item history
report for a few weeks, I notice that the only reason codes that are
displayed are the ones pertaining to inventory adjustment. It seems that
reason codes associated with discounts do not display in this report.
HELP! I need these to display to track discounts (and also store use)!
...outlook express 6.0 in ms 98
I cant seem to delete any of my sent mail messages in
Outlook express 6.0 i am operaitng in ms 98..up to 8400
Please help !
At the risk of being obvious, click on the first item in your sent items
folder while holding down the shift key. Then scroll to the bottom and
click the last item. That will select them all - or you can use any range
you desire. Then just click the delete icon or press the delete button.
Once done, you might want to empty the deleted items folder (assuming it
doesn't tell you there isn't enough room there and they'll be permanently
delete...Listing 'last used' date
Hi folks. We have literally hundreds of databases and my boss wants me to try
and produce a listing where we can idenatify the tables etc., and link a
'last used' date, in order to delete those that are no longer used.
Has anyone any ideas about how to go about this?
Mike MacKinnon wrote:
> Hi folks. We have literally hundreds of databases and my boss wants
> me to try and produce a listing where we can idenatify the tables
> etc., and link a 'last used' date, in order to delete those that are
> no longer used.
> Has anyone any ideas about how to go abou...Auto setup user with settings
Is there a way to configure outlook 2003 that connects to
an exchange 2003 server so that anytime I create a new
user on the terminal server.I would like it not prompt to
prompt for all the user settings every time. I would like
it to take all the defualt settings. Also I would like to
set this up with out a reinstall
Have you looked at the Office Resource Kit for assistance?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without rea...