"karlitos" <email@example.com> escribi� en el mensaje de
...error on page 01-13-05
I sometimes have the error message "error on page" below in the main
ms crm window, when I switch from Sales to Workplace , or from
Workplace to Home.
Is this a known problem, and is there a solution for this.
I do not have it always, and clicking on F5 resolves it.. untill it is
Any idea ?
are you running windows xp2 sp2?
if so you will need to apply the sp2 patches to the crm web server which can
be found on support.microsoft.com/downloads
Microsoft CRM MVP
I am "trying" to build a spreadsheet at work illustrating a gain/share
model that is triggered off of revenue & volume in work. Given that
information, here is one part of the spreadsheet I am having
For a plug number I have my current revenue set at 13,000,000. If i
was to receieve an additional 200,000 in work next year the following
year (13,200,000), that would make a revenue increase of 1.5% (VALUE #)
from the previous year. Based off of the the percentage of increase, I
would like to offer the customer a "discount" capped at a certain
Based on postings in the discussion group some people already have ver. 10.0
I understand it was released around June 18th. We are in Vancouver Canada
and have not received yet.
Just wondering if others have or have not received and when they received or
expect to receive.
We are up to date on the enhancement program.
It is downloadable from CustomerSource. The CD’s have not shipped that I am
> Based on postings in the discussion group some people already have ver. 10.0
> I understand it was released around June 18th. We are in Vancouver ...=vlookup
I m preparing invoice for my company which have multiple sheets like Customer
List and Pipe Size detail with rate of specific pipe.
I want to locate rate of specific pipe in Invoice. For this purpose I m
using vlookup function but when in that position second row is blank or same
then it returns #N/A.
I just want only want that it should be returned blank when row of Pipe
detail remain blank.
My worksheet have this type of data.
A B C D E F G
Description No. of Pipes (Qty in Mtr) Total Meter Rate Amount
1 063mm x 4Kg TKT 25 6 150 17.42 2613.00
2 075mm x 4Kg TRN 25 6 150 21.76 3264.00
...Mac Office 2004 on OS x 10.4.11
When i put in the CD to start the install process it does not recognize the CD. I have placed other CDs and DVDs in the drive and they all read just fine. I even put in the Office CD and tried to boot from the CD nothing happened. I am thinking it is probably just the CD and I should take it back and get a different one, but just wanted to try and confirm before I did that. <br><br>thanks
Yep, it's the CD, I would say.
Hold the CD up to a strong light and look for any scratches or fly-specks,
particularly on the inside tracks near the centre. CDs read from the inside
out....Summing the results of the VLOOKUP command
I am using the vlookup command several times to return values found in another worksheet. I would like to SUM the results of the vlookup command but since the values are not constants the SUM funtion is returning an error. How can I sum the results of the VLOOKUP command?
You should be able to sum (numeric) results of formulas, no matter what
What are the results of your lookups? What does your SUM formula look like?
What result did you expect? What did you get?
Microsoft MVP - Excel
"James" <firstname.lastname@example.org> wrote in message
ne...Pivot Table Formulas 06-06-10
I need to create a variance formula for the data selected in a pivot table.
My problem is that the data is coming in from one column and I don't know how
to distinquish the data by year in the formula. I have put a small selection
of my data below. I would like to show the variance between 2009 and 2010
for all months selected in the pivot table.
WDS# EA UOM PRICE EXTENDED Month Year
0623864 6 EA 9.73 58.38 Jan 2010
4286879 2 EA 2.784 5.568 Jan 2010
0623864 9 EA 9.73 87.57 Feb 2010
4286879 1 EA 2.784 2.784 Feb 2010
3514738 1 EA 13.72 13.72 Feb 2010
0623864 5 EA 7.85 39....vlookup #23
I hope you can help with the following:
I have to lookup a number in worksheet A within a range, "Range", i
the number is not available in the range, I want a "" in my cell. I
the number is available it should lookup the 18th cell. In the 18t
cell, I could have a date in there OR a words such as confirmed, route
e.t.c. If it is a date, it should provide me the date in my cell, i
it is anything other than confirmed, it should put a blank, if it i
confirmed, it should take cell m2+3 workdays. I have the followin
formula but I all blanks, something is not righ...Relationships 03-14-10
New to Access and using version 2007. I am building a database covering the
membership of a boating club. Looking at tables that would include:
* Primary Members Data - all members in the Club - type of membership, year
joined/left and similar. One record per member (so spouses/partnerships have
two line items)
* Members Contact Data - address and similar - again one line item per
* Members Boats Names and specifics
* Members history with the Club - membership class per year for past 25 years
And so on.
My question is the confusion of setting up the relation...vlookup in a chart
I am trying to create a chart which looks up a value and then depending on
this value uses a certain set of data to draw the chart. I know it can be
done, as I have seen it, but I am not sure what I need to do
Can you bee a little more specific?
Microsoft Excel MVP
"Lottie" <Lottie@discussions.microsoft.com> wrote in message
>I am trying to create a chart which looks up a value and then depending on
> this value uses a certain set of ...HyperLink in KB article 06-10-04
One of my clients needs are as follows.
In a KB article he needs to add a link to a web site say
for eg. google.com. He would add a word Search , which
would be a hyperlink . On clicking the Search it should
open a window with google.com set as default page.
Any help is appreciated.
vlookup table array - QOH!R1C1:R844C5, is there a way to specify range as
QOH! xlright,xldown as the number of columns and rows can vary?
ActiveCell.FormulaR1C1 = _
Dim ws As Worksheet
Set ws = Worksheets("QOH")
LastRow = ws.Range("A1").End(xlDown).Row
LastCol = ws.Range("A1").End(xlToRight).Column
ActiveCell.FormulaR1C1 = _
"=IF(ISNA(VLOOKUP(C2,QOH!R1C1:R" & LastRow & ...Need a formula 01-21-10
I need a formula that will compute an average for a random number of cells,
discounting other formulas in those cells as well as blank cells or any
containing zeros. Ex: AVERAGE( A1, B4, C18)
Final result must be an average of only those cells with a number entered
(as the result of another formula)
...if then statement with a vlookup?
I am trying to come up some code to search a workbook for numbers and
then put them in a column on the last page but if the number already exists,
do nothing. I need it to do this everytime I run the macro. Any ideas?
here is an example:
look for "day" if true then i want the number in column j on that page to go
to the last page in column k, but if the number is already there then do
nothing. if it is not there then the next cell down.
Does this make any sense? I think I confused myself.
Any help is appreciated
A little clarification ple...<no subject> 03-11-05
...vlookup or what?
I have a little database which arrives periodically, and I would like to
chart the number of members by nation. I can't recall ever having this
opportunity before. The nations are standard ISO codes (UA, UK, US, UY)
and not numeric. Is there a way to organize these entries somewhat
automatically for charting?
Alternately, I wondered if I filtered the nation column, is there a way
to export all the unique entries, preparatory to counting this by hand
(so to speak) . . .
Any advice would be gratefully appreciated.
P D Sterling
New York, Texas & Texas, New York
PD,...Check Digit in Modulo 10
I am trying to edit UPC codes, in MS Excel, that were provided to me by a
supplier without the check digit. Does anyone know how I can use Excel to
calculate the check digit?
Jumbo Electronics Co.LLC
> I am trying to edit UPC codes, in MS Excel, that were provided to me by a
> supplier without the check digit. Does anyone know how I can use Excel to
> calculate the check digit?
Here is a very srtong Addin that will do what you need to do plus more...Using VLOOKUP wrong?
Hey all, I've got 2 columns "A" has names & "B" has percentages. I've
been able to use the VLOOKUP function w/in the same workbook as the
data with success, however when I try to make a new workbook using
VLOOKUP I can't get the formula to work.
Here's what I thought the formula should look like:
Can someone please point out my idiocy & get me set on the right
Thanks a ton :)
> Hey all, I've got 2 columns &qu...vlookup is not a macro is it?
I have a sheet and it's a vlookup, I do not remember recording
anything, but howcome everytime I open the vlookup sheet, it has the
dialog box with button "disable macro" "enable macro".
Is this a bug?
Also I've protected a sheet, usually when you protect a sheet it also
hides the formula, isn't it? if so, why then some formulas are indeed
protected (can't see it) while some formulas are still visible?
Is this a bug?
Also, howcome every time I open my excel program, the personal.xls
Is this a bug?
thanks for all your answers and pati...Help on using Index, Match and Vlookup
I have 3 conditions MPn and Vendor code and Mfg code must be correct before
the vlookup function can search for the correct data.
I tried to use the following =INDEX('Vendor
part'!$F$16:$F$67,MATCH(D17,'Vendor part'!$A$16:$A$67,0)) it does work to a
certain extend but when it comes to the same vendor part number with
different Mfg code it use the first vendor description. Tried several other
combinations but not successful.
Can some one share your thoughts!!!!
You don't provide the background information about that other data, so I'll
I am currently running Office 2004 10.1.9 and want to install all missing updates. Which one do I install next and where can I find it?<br>
Well, Office 2004 is version 11, so you can't be running Office 2004
10.1.9. Office X was version 10.
In any app in Office 2004, run Help | Check for Updates.
If you are running Office X, then I believe 10.1.9 is the latest version.
To go to a new version, you would need to purchase either Office 2004 or
> I am currently running Office 2004 10.1.9 and want to install all ...Vlookup problems
I have Vlookups set up for a particular Spreadsheet. Each
month I just drop the new data into the first column.
Even though the number is formatted just like the previous
month (i.e general, text, whatever) my vlookup formula
shows #N/A. If i double click in the data cell and hit
enter, the vlookup formula works. can you tell me why, or
if there is a better way than clicking and hitting enter?
do you have your automatic calculation turned on?
~~ Message posted from http://www.ExcelTip...budget day 10
my budgeted amounts are all messed up. some items are triple what they
should be for each month, others are 0.
is there a way, what is the process, to start over with budgeted amounts?
they seem to be sticky, in the sense, i can start a completely new budget,
and the new budget remembers these tripled amounts, doubled amounts, and the
0's instead of amounts.
iow, where/what part of money are the budget amounts stored? are they stored
in the recurring bills/deposits? should i delete all the bills and deposits,
save, and reenter them? maybe call them by a different name?
why does th...vlookup function #5
vlookup gives the result / value as soon as soon as it finds the first value.
How can i have rest values in excel satisfying same conditions , 2nd , 3rd
try the following kin of array function:
and copy down as far as needed
>vlookup gives the result / value as soon as soon as it
finds the first value.
>How can i have rest values in excel satisfying same
conditions , 2nd , 3rd