I am calculating percentages and in one cell the formula works and in the
next it gives me a #value error, the formulas match perfectly just different
cells. Can anyone explain this. This is the formula
You sure you don't want a formula like:
Todd Nelson wrote:
> I am ...Bulk upload of pick list values
I have created some new fields in CRM which are picklist type. Is there any
way to bulk upload picklist values into that field so I would not have to
type them manually? The problem is I have some picklist fields which should
comprise more than 100 picklist values and to think of typing them manually
Unfortunately you do have to type all the values in the picklist manually...
"Mikkhail" <Mikkhail@discussions.microsoft.com> wrote in message
> I have created some new fields in C...Account for null values on a report
Hi - i have several reports that i am creating for users to input their
required criteria - i.e. a report using query by form - they all work fine
unless the criteria a user enters results in an empty query. the fields on
the form are all summed or counted e.g. =Count([loanID]) to count the number
of loans made, =Sum([amountloaned]) to show the total amount of money loaned.
I am trying to account for the null values otherwise the fields on the
report just show 'error'.
I a trying to use the Nz function but am unsure if it will work on a field
already using another function
=...Transpose stacked lists of values
I have a column with repeating labels, and a second column with values.
Column A Column B
I need to transpose these so that the Labels in column A become column
headers, and the corresponding values for each label appear in the rows below
each column header.
Label1 Label2 Label3
Value1 Value2 Value3
Value4 Value5 Valu...How do I create a chart out of a list, instead of number values?
I'm trying to create a Pie Chart from a list of Questionnaire results.
Each questionnaire's results will be recorded in a row.
For example, one of the questions is "Gender?" and I have asked 5 people.
Results: Male = 3, Female = 2
My Spreadsheet therefore looks like this:
A | B
2| Male | Female
3| 3 | 2
I can't get a graph for the first one, but can for the second.
You might be thinking why I don't want to use the 2nd method...LOOKUPS
I am having a problem with one of my spreadsheets for my GNVQ I.T.
coursework. Please help!
My spreadsheet is for a boat hire company. On one table is a list of the
boats, times to hire the boats and the cost to hire the boat for that amount
Boat One | 2 hours | �25 (per head)
Boat One | 3 hours | �35 (per head)
Boat Two | 2 hours | �30 (per head) etc. etc.
On another sheet, there is a table that lists the customers that have hired
the boats, which boat they hired, how many people are on the boat and the
time it has been hired for.
Mr R Brown | Boat One | 3 hours | 4 people ...Serial Number Problem
Hi Everyone, we run Dynamics on our server anyway we had HUGE problems and
lost a lot of work.....anyway after fixing lots up i still have one MAJOR
Serial numbers for items in the system do exist if you look up inventory ~
There is a list of serial numbers in stock ready to use.
But when we go to do an invoice there are no serial numbers, it asks you if
you want to overide the quantities...
Our problem was we lost our inventory file therefore we had to put an old
file back on...although these serial numbers are there we can not use them
which also means i cant put t...How to get polynome (or other type) coefficients of a trendline?
...Duplicate Element Names in Serialized XML
Hoping someone can solve a problem for me.
I am modifying the schema for a rather complex web service written in
VB.NET. The services uses a large number of serialized classes to output the
overall XML. The problem I am having is that I require 2 XML elements of the
same name to be serialized from the 1 class. Due to the way the web service
is written only 1 of these would be ever be called at a time. However, it
seems that I get an exception if the same element name is used twice in one
class.. any ideas?
'start class here
<XMLElement ("elementName&q...Need value looked up based on SMALL() result
I have a sheet like this:
cat dog horse rat bird
9 6 8 1 3
I use the SMALL function to get the smallest three numbers
I need to find a function that will return the corresponding
Put this formula in G1:
and copy across to H1 and I1.
Hope this helps.
On Aug 3, 12:30 am, "Jorabi" <jor...@pobox.com> wrote:
> I have a sheet like this:
> cat dog horse rat bird
> 9 6 8 1 3
> I use the SMALL function to...Default Activity view page to phone call type
Anyone know how to default the Activity view page to the type phone call? Is
there some jscript I can put in the OnLoad event?
...Assigning a value to a text
I'm currently doing somework in Excel and would greatly appreciate some
help since I'm stuck.
I've reached this part in which you have to calculate the dscounted
price for each group of products.
The discounts are ranged as Normal (5% discount), Special (10%
discount), Exclusive (15% discount). When setting up you had to state
what category each product was without indicating the % of discount. So
I was wondering, if anyone knows how to *embed* the discount into the
text, you know masking it. So any onlooker wouldn't notice it, but I
can still calculate the discount.
...Short date format in strongly typed dataset date column.
Is there a way to save date data in a short format rather than the long form
which a strongly typed dataset saves it which looks like this:
d3p1:WeekEnding="2003-02-02T00:00:00.0000000-06:00". I would like to
shorten it like this: ="2003-02-02"
...-> 2003: Plain text wrapping as I type? <-
I'm using Outlook 2003 and have set the auto wrapping to 76
for my plain text messages.
At work, they autowrap as I type.
At home I can type miles and miles of text without wrapping
appearing in real time. It's wrapped only when sending the message.
I'd like Outlook 2003 to wrap text as I type so I can know how the
message will look like before sending it.
I have applied all the patches.
Any clue why I get the correct behavior at work (where I have
Office 2003) and home (where I only have Outlook, without MS
Thanks for any help.
St...subtracting values in Access
Is there any way to subtract values in two different rows in Access? For
example you have a 9 in row 1, and a 5 in row 2; Is there any way to subtract
the two. I know you can run formulas across columns, but what about rows?
You can but you have to control which record you are looking at.
If you post your table structure, listing field names, datatype, and sample
data someone ould suggest how.
Build a little, test a little.
> Is there any way to subtract values in two different rows in Access? For
> example you have a 9 in row 1, and...Serial Motor
How do you control a motor via serial port? What language should I use?
Justin Case wrote:
> How do you control a motor via serial port? What language should I
I don't know, but it certainly isn't possible with SQL Server ...
Bob Barrows (reb01501@NOyahoo.SPAMcom) writes:
> I don't know, but it certainly isn't possible with SQL Server ...
What? You can't control a motor with an engine?
Erland Sommarskog, SQL Server MVP, email@example.com...value inputs..another formual question
Well I'm full of questions today...I'm really starting to understan
Excel and I'm enjoying working with it.
I'm making a sheet that will keep track of someone that is running
tab with us. I'm inputting how much is owed on each specfic day, an
the value's are added up and outputted in a "grand total" cell.....
Now what happens when this person pays on the account, is there any wa
I can input how much he pays which will be subtractred from the gran
total, without destroying any information of past money spend (i wan
to be able to keep a grand total, average ...Excel Range Value issue (Excel 97 Vs Excel 2003)
I have some VB6 code which was originally written to populate a
spreadsheet in EXCEL 97. Basically, to cut a long story short,
what the code does is it populates a variant array by calling a stored
procedure. The variant array in question is populated with 3 elements
(a date, and 2 floats).
The array is then passed to Excel like this.
Dim xlRng As Excel.Range
xlRng.Value = vntDataArray
In my particular scenario, the first four rows have the following dates
in the "dd/mm/yyyy" format.
These dates are exported perfectly to Excel 97...serial port communuication
I m communicating to a printer device through serial port.It
is failing to open the port,but when I disable and enable the com port
in device manager,it works fine(i.e)it communicates with the printer
and reads the configuration settings of the printer).
are u leaving the port opened when ur program terminates ........ what is
the frequency of u disabling/enabling port ....... after every run ......
some times works some times not ..... ?????
"hari" <firstname.lastname@example.org> wrote in message
news:email@example.com...Serialization of jagged Arrays Issue
I m trying to return an object (of my own written class) from a web
service that contains jagged Arrays as public variables. Asp.Net is
showing me the its serialized version on the browser when i invoke the
service during test.
public class returnType
public _chassisdata chassisdata;
public _wheel upsteps;
publi...Word 2008 keeps crashing after a document is open, a few minutes after typing anything
Operating System: Mac OS X 10.6 (Snow Leopard)
For the last two weeks Word 2008 has been freezing after a open my document and start typing. The documents were created in word. I removed the "Normal.dotm" file as some suggested for similar issue. But it does not solve the problem. I reinstalled office with all updates again and nothing. PLEASE HELP! I'm writing a dissertation! <br><br>Here is the "problem report for word". I'm sorry but is long. <br><br>Date/Time: 2010-05-10 21:20:20 -...specifying Commtimeout values
I need to set timeout values for readfile and writefile, the
timeout for readfile is 300milliseconds and for writefile is
I read the MSDN documentation, but I m not clear to specify the
timeout values Can any one help on this.
cto.ReadIntervalTimeout = ?;
cto. WriteTotalTimeoutConstant =?;
"hari" <firstname.lastname@example.org> wrote in message
> H...getting value of named range
I have a named range. Lets say it goes over lots of cells.
A1 to E20
Can I get the values out as a string? Single string.
I have tried some things like:
whoops, this should be in programming
"greg" <email@example.com> wrote in message
>I have a named range. Lets say it goes over lots of cells.
> A1 to E20
> Can I get the values out as a string? Single string.
> I have tried some things like:
> excel.Wo...Use of Monotype Sorts Font and Value 4
When I enter in a cell the value 4 and change font to Monotype Sorts
instead of getting a single CHECK-MARK I get the Check mark plus 3 other
that look like a pencil stub. I only want to Check Mark.
I can't replicate your problem. I get only a check mark. Are you
sure there is nothing else in the cell. In another cell, use a
formula like =LEN(A1) to ensure that there is only one character
in the cell.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"JMay" <firstname.lastname@example.org> wrote in ...No text converter is installed for this file type
This is a multi-part message in MIME format.
I am now facing a problem in opening a ppt in Powerpoint 2003, an error =
display as follow:
"PowerPoint can't read the outline from filename. No text converter is =
installed for this file type."
My platform status:
1. Windows XP Professional SP3
2. Microsoft Office 2003 SP3
3. Office 2007 Compatibility Pack installed
Who can help me?