Count but ignore duplicate data
Hi Expert, I need your help on how to count data but to ignore duplicates.
Below count results should be = 3 (ignore duplicates)
Thanks for your support,
Jacob (MVP - Excel)
> Hi Expert, I need your help on how to count data but to ignore duplicates.
> Below count results should be = 3 (ignore duplicates)
> Inv No.
> Thanks for your s...Option to use current cost in formula calculation in POs
In purchase orders, our customers need an option to use the current cost
typed into the cost column when performing calculations with the formula
This is because many of our customers need to reduce the value of the PO by,
for example, 5% because they have met payment terms that give them a
discount. The simplest way to achieve this is by using the current cost that
has been typed into the cost column.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree&q...How to match fields and retrive data
Hi I have one sheet like:
where I store product informations
in another sheet I have pivot table where I have information about the
How can I make excell to look in second sheet for particular value and
retrive the price in first sheet ?
Please help me with this as I have no idea
use VLOOKUP. See:
"Piotr" <email@example.com> schrieb im Newsbeitrag
> Hi I have one sheet like...Validation and entering data
I've got two spreadsheets. One has got data on, and one is blank but with
validation on (from the data -> validation menu). I need to get the data
onto the sheet with the validation and got through the validation process.
If you paste or use vb commands such as range or cell, the validation is
Is there a way of simulating the act of typing in the data into the
spreadsheet? Unfortunately I don't have control from either the source
sheet, or the destination, but I can set up a routine to transfer the data.
...HELP- Copy a Data Series to Other Graphs? #3
I'm using Excel 2002 and I've got a lot of XY (Scatter) graphs.
When I add a new data series to one graph, it is defined by 3 values
(Name, X Value and Y Value)
If I want to add this data series to 7 or 8 add'l graphs, I know that
I can copy/paste these 3 values to each of them.
Is there a simpler way to accomplish this?
...Add data from other sheet to the data present in this sheet
I am trying to add data from another sheet to the data present in this sheet.
I dont know what the formula has to be or how to start. I have 2 sheets,
"today" and "till date". "today" will be updated on a daily basis. I want a
formula where on "till date" sheet, today's data is added to the previous
days dat and show son "till date".... Plz help me...
How about using a built in form?
Select the complete data with headings on 'Till Data' Sheet
Press "Alt+D" and then O.
Simply add records which will update your...Multiple Tables in Query not Listing Data.
I cannot seem to get this correct. I am trying to run a query on two
databases one of which is linked to the other. I am trying to get the query
to display a 0 for the total defects counted from one table based on the date
and time from another table. So far when I run the query I get only the
counts from the values that are not null.
Here is the SQL Statement:
SELECT Pro_Total_by_Cell.Cell, Pro_Total_by_Cell.Shift,
Pro_Total_by_Cell.Time, Pro_Total_by_Cell.ProTotal, Pro_Total_by_Cell.Time1,
IIf(IsNull([Counto...tools > options
In pub 2003 I go to tools > options and set file locations for publications
and for pictures.
Pub 2007 does not seem to work the sane way.
How can I tell pub where to look for files and where to save them?
Weird ain't it?
I think they forgot to put it in.
Microsoft MVP Expression
"SOB711" <SOB711@discussions.microsoft.com> wrote in message
> In pub 2003 I go to tools > options and set file locations for
> and for pictures.
>...Entering data in 3 ways
I have been bilding a form for orders (frmOrders) including a subform for
order detais (frmRows). In the frmRows is a control for UnitPrice. I should
be able to enter data into it in 3 ways:
1. Directly from table Products.
2. Based on calculation square meter*m2Price.
Placing a sentence =IIf(m2Price>0;m2Price;ProdPrice) into the UnitPrice
control works in cases 1 and 2 but entering data manually does not.
Now I have solved this problem by macro: doubleClicking on control UnitPrice
copies the value from m2Price and I can edit the UnitPrice control. I know
there must be m...Fax Line utilization with Start and END time data
I have large list from our fax servers that produces a lof with :
Start of FAX Connect date/time, End of Fax Connect date/time
I know I have 24 lines but need to find how many lines have I bee
using historicaly to do capacity planning.
Message posted from http://www.ExcelForum.com
...The option to add clip art in my email is not there now.
I need some assistance.
When I go to compose new email you should be able to click on insert
and see where is shows picture and it should have a right arrow and
when you mouse over it a drop down menu should be there and one of the
options should be Clip Art.
At this time there is the option to choose picture but thats it no
arrow with a drop down menue with any other options.
I dont know where it went or what could have happened to make it not
I have all recent updates for Office 2003 installed.
Are you still using Word as your email ed...XSD Validation Question
To you XML validation experts:
I have a schema that validates an XML file, but there are a couple of other
types of validation I'd like to do on it. They are basically string fields
that must be validated against a set of possible codes, but there could be
tens of thousands of possible codes. Naturally, these codes are in a table
in SQL (actually there are a few code types, but the problem is the same for
In the past I have always done this as an additional code step AFTER schema
validation, but I am being asked whether it could be "plugged into" the
schema validation...Specific filter for the data in a field
In a field there are entries that have the symbol * entered for some reason.
How can I filter and find all the data in that field that has "*" entered. I
can't seem to find the filter for it.
On Wed, 3 Feb 2010 14:29:28 +0200, "Dimitris" <ipackREMOVE@otenet.gr>
Use this expression:
This means a wildcard followed by an asterisk followed by a wildcard.
Microsoft Access MVP
>In a field there are entries that have ...location bcm data
I have just installed outlook 2003 + bcm. I copy the .pst file from to my
notebook on a daily basis. I discovered that the bcm data are not copied
together with the .pst file. I have tried to find the location of the bcm data
file but it is nowhere to find.
Can someone give me a clue?
...change general format to time w/o losing the data
Help - I have several spreadsheet with military time i.e.
1701, 1615, etc. The cells are in general format. Since
I need to calculate hours from these times, I tried to
convert them to [h]:mm but when I do, it changed the
number 1701 to 40824:00. I tried to change the cell format
to hh:mm but it gave me zeros. I use Excel 2000. Thanks.
With your number in cell A2:
(When sending e-mail, use address arvil<At>tarkon.ee)
"klaire" <firstname.lastname@example.org> wrote in message
news:09db01c4a620$e775390...How to put cell data in chart y-axis?
I am having serious trouble with my excel system! I have 1 column for time,
another for temperature, I need time to be on the y-axis and Temp as a line
on the graph. Damn auto-grapher creates a graph with both time and temp as
lines in the graph. PLZ HELP!!!11
P.S Hurry and answer this i have only today to do this!!
If you add a column header to your Time column you will help excel to guess
your data layout.
It expects the first column to be Category or X values. The second column to
be Y Values.
By the way ...cluster column chart with data point labels
I'm trying to create a cluster column that has a label above each data
The columns are the total number of an event that happened and then I
need a label that shows what % of a goal those number of events
represent. There is no relationship between the data and the % label.
Jan (cluster 1)
A: 34 label: 98%
B: 52 label: 102%
C: 23 label: 96%
Feb (cluster 2)
A: 36 label: 102%
B: 56 label 110%
C: 21 label 92%
Can someone help me design this chart?
Try one of these utilities which add labels from a worksheet range to a data
series. Both are free, e...string data, right truncation
I'm getting this error while trying to store data. I'm using an odbc
recordset. The problem is that I've got around 400 fields involved in
the insert statement (main table, plus detail tables). My question is
this: Is there any way to find out which field(s) are causing this
This is a cgi "script" on a server, so I can't debug with a debugger.
(makes the whole situation a little tougher)
Maybe the string size is too small to hold the total sql-command?
"Cliff" <email@example.com> schrieb im Newsbeitrag
news:1187195184.051633.264680@22...CRM 3.0 Local Data Group Maintenance
I'm missing a tool to maintain local data groups for new users.
It's not feasible to manually generate, configure 20+ new datagroups
for each new user!!!
what can you recommend?
will there be a tool from microsoft (CRM 4.0 :-( )?
...Data from non-adjacent cells as input for Linest #2
I would like to use data as input for Linest that is in the following
known y: A1 to A3, A10 to A12
known x: B1 to B3, B10 to B12
I have the feeling that this is almost answered in the following
posts, but I do not understand it:
...Issue with being able to select 64 bit Data Sources in Excel 2007
I am having a couple of issues with Excel 2007 and being able to retrieve
data into Excel 2007.
The first issue is that I cannot see a System DSN that was added through the
64 bit ODBC Administrator screen on Windows 7 in Excel 2007.
What I do is add the System DSN and when I open Excel 2007 and then click on
the Data tab and then click on From Other Sources then click on From
Microsoft Query the Data Source I added is not in the list.
So since the System DSN did not show up I removed it and added a User DSN
and did the same steps as above and when I open the table I ...Data points going from axis to axis
Without necessarily deleting the chart and then recreate a whole new chart,
how can I get the data points to revert back to being in the center of all
columns rather than equally spaced starting from the left axis to the right
This issue was brought about by way of using the Area method for one of the
data series, but went attempting to revert back, it doesn't go back to the
original line data format as described above? It goes back to the line, but
the data points are not at the same places.
Ronald R. Dodge, Jr.
Master MOUS 2000
Try ...XL2000: "Filename is Not Valid"
I found article ID 213983,
http://support.microsoft.com/default.aspx?scid=kb;en-us;213983, that finally
answers my question why I sometimes can't open files. This has been a great
mystery to me because I can open the files if I copy them to my local hard
drive. Unfortunately, for a lot of reasons, I can't rename the directories
or files. Is there any way to get around the 218 character limit? Is this
limit carried in later Excel versions?
...Formulas no longer auto update with newly inserted data!
All of a sudden, I add sales numbers to a row that was
included in the summation. The sum function did not sum
the newly inserted information until I double-clicked on
the formula cell and re-entered. This now holds true for
all of my linked worksheets and formulas, rendering me
useless for entering additional data. Anybody know why
this is happening and how to remedy?
you probably have disabled the automatic calculation. Goto 'Tools -
Options - Calculation' and check 'Automatic calculation
> All of a sudden,...Merge into same document using different data sources
I have a template file that I use as a mailer. Each week I set up my merge
fields and merge from an excel data file. The following week I want
everything to look exactly the same but want to merge from a different excel
list. I open the publication, tell it to proceed without connection to the
datasource (my old list), choose tools, mail merge, use an existing list ...
and all of my perfectly placed merge fields disappear! So every time I want
to use another list I have to put my merge fields in again. My headers are
the same in every excel file so mapping should not be a problem. ...