Can someone explain why these two expressions differ referring to the value 5?
IF(A2:A10<5 etc. ) but
COUNTIF(A2:A10,"<5") requires a comma and quotes
Wouldn't it make sense for them to be the same?
For us it would seem to make sense, but for the computer not so much :-)
My understanding is that in the IF statement the <5 is a Comparison
Operation which is a part of the 1st Function Argument whereas in the
COUNTIF it is a Criteria Reference supplied as the 2nd independent Function
Argument. If it stood alone as simply <5 it would ...Outer Join and a two step query
I need to list which dog breeds have never been sold at the Store by using
Outer Join and a two step query. Anyone can explain for me Out join
Thank you all
My tables are as follows:
Table Animal has
The following SQL should list which dogs have not been sold at the store:
SELECT Animal.AnimalID, Animal.Category, Animal.Breed
FROM Animal LEFT JOIN Saleanimal
ON Animal.Animal...connecting two chart lines
I have two data series which represent declining balances
for a home loan. At some point I transfer the balance in
series1 to series2. So Series1 stops at its last balance.
Series2 will jump vertically, because it has the balance
from series1 added to it. Then series2 once again
continues with a declining balance. My question is how do
I create a vertical line to join series1 with
You could add a third series with only two points, the endpoints of the
two series. If it is really a vertical line, you could also use an error
bar of the appropriate length on on...Print on two sides
I have an application that printed multiple pages and I have a printer
(BROTHER 5370DW) that allows this. I select the printer using the
CommonDialog1.ShowPrinter command and then click on the printer
preferences to select two-sided printing. However, when the actual
printing takes place is does not print two-sided.
Is there something in VB print methods that would over-ride this option
or not allow it?
On Jun 15, 2:40=A0pm, M Wade <nowh...@columbus.rr.com> wrote:
> I have an application that printed multiple pages and I have a printer
> (BROTHER 5370D...put more than 255 field on report from two tables
My project is in MS Access 2002.
In that I want to generate Report which contain fields 258.I can put
255 fields but how can i add more 3 fields.
when i generate report for 258 fields than it will show msg too many
how can i solve this problem?
It is a bit unusual that you would need to use that many fields. However, you
can get around this limitation by using subreports.
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
> My project is in MS Ac...Two Screens Part 2...
We are running MS Excel 97 with MS XP OS on a computer
with a Matox drive where we have two screens.
Excel used to open on the left hand screen but now opens
onto the right hand screen.
I'm unable to resize the excel application by selecting
How can i get it to re-open on the left hand screen as a
Note: The re-size button acts the same as the minimise
I presume you're running it in full screen mode? Click
on the box at
the upper right of Excel which allows you to resize the
window. At that ...More than two Recipient Update Services
I have noticed that my Exchange 2003 servers have 3 Recipient update
services. One is the Enterprise one, but the other two are just Recipient
Update Service and Recipient Update Service 1. Why would I have two of them,
can can that cause problems? They are pointing to two different domain
controllers and we only have a single domain in our forest.
Thanks in advance
On Fri, 20 Jan 2006 06:20:02 -0800, "Marc"
>I have noticed that my Exchange 2003 servers have 3 Recipient update
>services. One is the Enterprise one, b...Comparing two spreadsheets.
I have two spreadsheets here, which hold a list of people and there
addresses. However, the original sheet is different to the new sheet,
as some people have been removed, changed address etc.
I need to print out some address labels for all the 'new' or 'changed'
people because I've already done a label list for the originial sheet.
I cant find anything in excel to compare the sheets, someones telling
me pivot tables but I dont think that would work? I've tried 'Excel
Compare' which costs money before it will display ALL the changes, is
there any other way ar...CountIf Statement
Can anybody help?
I am creating a formula in a cell of a spreadsheet which will
Count all in stances of "distribution centre" within a column
This is achieved using the
=COUNTIF('calls closesdon 3 - 4 Dec'!G4:G14, "GROUP")
I was wondering whether it was possible in excel to use a statemen
=COUNTIF('calls closesdon 3 - 4 Dec'!G4:G14, "GROUP") and (nex
Message posted from http://www.ExcelForum.com
You can use sumproduct to count with more than one condition multiple ranges
=SUMPRODUCT(--(Range1="GROUP&...How to fill cell with two combobox values?
I am looking for VB code for command button that fills two combo box
values and a toggle value (Y/N) behind each other in one cell.
...Can I use conditional formatting between two sheets to track chan.
I need to be able to track changes between two sheets. One will be locked and
the other able to to be edited. I want to turn any cells blue that are
changed and not equal to the static sheet. Conditional formatting won't let
me go between two sheets. Is there any other way to do it? Thanks. D
Yes you can, you need to use a defined name (insert>name>define) and not
something like =Sheet2!A2
"dawleen" <email@example.com> wrote in message
> I need to be able ...Countif ...
I have a column with phone numbers. I want to count how many phone numbers
have the area code "214" and "972".
Thanks, the first formula worked.
"Jason Morin" wrote:
> The formula depends on how your phone numbers are formatted and whether they
> are text or actual 10 digit numbers. For example, if they are text and you
> simply need the first 3 numbers in the cell, try:
> If the area codes are enclosed in parentheses, you could use:
> =SUM(COUNTIF(A1:A10...Criteria/CountIf and Pivot Table
My data looks like this
ID Date CWA
1 08/12/2006 0
2 08/13/2006 1
3 08/14/2006 1
4 08/01/2006 0
Based on the above data, I want to create a pivot, by month (I know I
only have Aug here)
to show the following:
Sum of CWA
Count of CWA
Percent of cases that were submitted with CWA.
The CWA is an indicator field that looks at another field (not listed
here) to determine if there is cash in a...Two Deep XML?
This is a multi-part message in MIME format.
I have some code which creates an XML output like this:
Here it is:
newElem =3D doc.CreateElement("Product");
I am trying to solve the following problem
i) cells A1 to A10 have either M or F (male or female)
ii) cells B1 to B10 have either (grades) A B or C
iii) I want (eg cell B13) to state the number of female students who scored
A... and cell B14; how many female students who gained B etc
I have tried various things including countif, sumif etc. It seems like a
straight forward problem but the solution evades me!
in Cell B13 and filled down to Cell B15.
> I am trying to solve ...Find next record according to specific criteria
I have a field on a form that has a checkbox. I want to make a button
that will go to the next record that doesn't have the checkbox checked
(I don't want to filter the records, just to advance to the next
unchecked record). What code do I use to accomplish this?
You can use the FindNext method to do that:
.FindNext "[CheckBoxFieldName] = 0"
If .NoMatch Then
MsgBox "No More UnChecked Records"
Me.Bookmark = .Bookmark
Note CheckBoxFieldName is the name of the...IF two different conditions are met #3
The array isn't working eithe
AnnaV's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=961
View this thread: http://www.excelforum.com/showthread.php?threadid=27065
Have you tried Jason's suggestion?
"AnnaV" <AnnaV.firstname.lastname@example.org> wrote in message
> The array isn't working either
> -----------------------------------------------------------------...two ComboBox questions
hello - I have some code attached to several of my ComboBoxes that works
fine, but I'm not if it is 'best practice' coding. I'd really like any
suggestions for improvement:
a) If I have to walk through the items in a ComboBox, i do this...
n = 0
Do While Not IsNull(Me!cboGroup.ItemData(n))
... code here ....
n = n + 1
Is this the best way to walk through these items? Is there a better way
involving 'Do While Not rs.EOF'?
b) Say I have three ComboBoxes and I only want to proceed
if they all show valu...Excel countif and
is there a "and" condition if you use countif or sumif?
2 < countif(b1:b4,"=c")and(a1:a4,"=1")
"KEN" <KEN@discussions.microsoft.com> wrote in message
> is there a "and" condition if you use countif or sumif?
> 1 c
> 1 c
> 2 < countif(b1:b4,"=c")and(a1:a4,"=1")
...CountIf with And
Novice Excel user on Excel 2003. I have a yearly data input sheet to track
codes. I use the date (fomatted as 1/01/2009) and a code. I want to track
the codes in a mothly chart for ease in summarization and improvment
tracking. The codes are used to define a department and an error in that
department (code 1a means - AR department and error a). I need to pull and
total the amount for each code for each month. After searching for a while
it seems that using CountIf with And does not work. Any suggestions would be
=SUMPRODUCT(--(MONTH(date_range)=4),...sumif (with two criterias)
I use following Syntax which works very well:
the cell "e77 " is the criteria
how can I summarize when I use two criterias?
For example the criterias are on cell E777 and F777
You can concatenate the values of E777 and F777
e.g =(E777&F777) or =concatenate(E777:F777)
Result is E777F777
and you will have the result of E777F777...
With this result you can use the sunif function
>I use following Syntax which works very well:
>the cell "e77 " is the criteria
>how can...Two filters in a pivot table
I have a pivot table that I'd like to filter for two criteria like an OR
instead of an AND.
I have two fields for animal handlers, keeper 1 and keeper 2. They are
linked to a table called keeper ID.
Animal Keeper1 Keeper2
Scooter Jane Kim
Tilli Kim Ellen
Cactus Ellen Todd
I'd like to filter for which animals have been handled by keeper 1 OR keeper
2. So I'd like to see which animals Kim or Ellen have handled, resulting in
Scooter, Tilli, Cactus. Or which animals Kim or Jane have handled resulting
in Scooter, Tilli. The Pivot Table filters filter like ...Two Color Questions
I work with Visio on two computers. When I right click on the page, one of
the choices is Color Schemes but only on one computer. The other computer
doesn't have that choice. How do I add that to the right click or where else
can I find the "color schemes" box?
Also how do I change the color of the page? I have done this before and
can't do it again?
Thanks for your Help
In Visio 2007, try:
Format \ Theme
Tools \ Color Palette
Tools \ Options \ Advanced \ Color Settings
"jcreek" <email@example.com> wrote in message
n...Adding two fields to a table
I current have the following code which works perfectly now:
[CODE]CurrentDb.Execute "INSERT INTO [Input] ([Loc_Desc]) VALUES (""" & Me.
List12 & """)", dbFailOnError[/CODE]
I would however like to add another field's information named (Lnd_Desc) as
well in the same row of table (Input). What should my syntax look like for
Message posted via AccessMonster.com
INSERT INTO [Input] ([Loc_Desc], [Other Column]) VALUES
(""" & Me.List12 & ...two colum lookup
i have two colums F & G which i am trying without success to marry up t
colums A - E (colums C - E in this case have been removed ). what
would like to achieve is the rows from colum A -E marrying up with th
rows in colums F - G.
can any one suggest a method of doing thi