Pivot table and counting.
I have a pivot table that gives me the number of rides done by a van. I can
have the pivot table return the number of rides, but what I need is the
number vans that participated for a certain day. Example, it is possible to
have 27 trips done by 18 vans, how can I count the number of vans and not
addup the van number?
Any help appreciated.
We need a bit more information on how your source data table is set up.
What information do you have in each column?
sacredarms <email@example.com> wrote:
> I have a pi...Using form to enter "query criteria" (between values)
Good morning everyone,
I want to create a form with two boxes, where first box is lower limit of
the value and the second upper limit. This values should be used in my query
as filter criteria.
Like this (query filter criteria): > "textbox1" AND < "textbox2"
Does anyone know how I can build this in a form (i.e. connect my textboxes
and query criteria)?
By thinking about for another minute I found the (simple) answer.
In the query criteria I put the following expression:
BETWEEN [forms].[nameofform].[NameofDatefield1] AND
[forms].[name...1. Selecting field with "enter"; 2. permanently accepting macros
I have recently upgraded to Access 2007 and two characteristics of my former
database are not coming through & I want to get them back. First, in Access
2003, I had set it up so that if I hit "enter" the entire field would be
selected. Now "enter" causes the cursor to jump to the next field. How can
I change this?
Secondly, In my database forms, I had incorporated buttons. Now, each time
I open the database, I am given a warning about macros and I have to manually
tell the program that the macros are trusted. Unfortunately, Access doesn't
accept this an...comparing data #2
I was wondering is there a way to compare data from 2 columns in a side
by side comparison. I have a large list of numbers and what I want to
do is copy another list of numbers into the spreadsheet. But I want the
numbers in cell A1 and B1 to be equal if they are is not a match then
leave cell b1 empty. I want that to continue all the way through the
Do you want to end up with 2 separate columns, or are you wanting to
merge the 2 lists into 1 list, without duplications?
I want 2 side by side columns. With the numbers that are equal right
next to each othe...Cycle Counting
I am looking for ideas on how to cycle count serial
number tracked items without increasing workload. Our
serialized items are barcoded but the problem is the are
situated on the pallet incorrectly and the pallet is
placed on a third level of a racking system.
If we could just cycle count based on item count
and not include the serial number it would make it easy.
Is this possible in Great Plains. We are running Great
Any suggestions are greatly aprreciated.
I would like to know how which formula I should use to count some codes & to
ignore the duplicated codes, for example in column A:
Now, I want Excel to count & the result is 3 which are:
Yes I can use PivotTable, but I would like to use a formula because I have
to deal with this every day.
I appreciate your support.
COUNTIF will do it.
=COUNTIF(Rng,Rng), where the criterion is the same as the range:
> I wo...2 2k7 servers, no owa?
i have 2 e2k7 servers on a test envirnment with mailbox, hub and client
access roles on two domain controllers(both global catalog).
i'm testing recovery procedures so i shutdown server1, after that i can't
access owa on server2 and all exchange services crashed, after starting
them, owa times out and load nothing.
...To keep in just one cell all values related to a monthly rate
I have to update in a monthly basis a currency rate.
I know that there is a function, formula (or something like that) to link a
month descripton to a number.
I would like to select correspondent month and the cell be updated with the
Data Validation dropdown list for choosing the month combined with a lookup
table and VLOOKUP function.
For help on creating data validation dropdown lists see Debra
For help on VLOOKUP to populat...How do I stop a user with no admin rights from reading other email #2
How do I stop a user with no possible admin rights from reading other emails. How is this possible.
...Can I limit a cell to 2 characters?
Is there a way in Excel to limit the number of characters in a cell?
By checking the length of the cell
in your custom validation.
Look for Data Validation on Debra Dalgleish's site.
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Frankc" <Frankc@discussions.microsoft.com> wrote in message news:842747F1-1792-4BB5-B3CE-707C7CC5F88F@microsoft.com...
> Is there a way in Excel to lim...How do I count the # of times a value reoccurs and plot it over ti
I wish to plot a number of errors made by each users and compare it over
time. I have a column of user ID's and a column of dates. I want the chart
to count the number of times each user ID appears and plot against it's
corresponding date. However, each time I try to do this, the chart appears
wrong. Any ideas?
In article <9595B2A1-8282-4AB3-8511-A6776E108164@microsoft.com>,
> I wish to plot a number of errors made by each users and compare it over
> time. I have a column of user ID's and a column of dates. I want t...Converting from Quicken #2
I have just purchased Money Standard and want to convert my quicken data, but
it keeps telling me that it can't find all the Quicken files. I have
searched teh whole HD for files with the same name as my data file and copied
them to the same dir but still no luck. When I download the demo from the
web it converts it with no hassles but then I can't get the satandard
version to open that file.
Any help would be appreciated as I don't want to loose years of work.
In microsoft.public.money, MCLuke wrote:
>I have just purchased Money Standard and want to convert my...Incorrect value on the SMTP HELO/EHLO
I am looking for some help on this one. I inherited some exchange
admin duties and to be honest it's not my specialty.
We recently switched IP providers and our IP addresses changed. This
also means we changed our DNS provider and I believe they have the
appropriate zone records setup, although this may not be the case
since I don't recall having this issue with our previous provider.
When sending email to external email addresses we get NDR's from
several different ISPs usually stating they are blocked because our IP
address does not match the domain.
The mailserver identifie...error in compiling 2002 code in 2005 #2
i have code build in visual studio 2002 .
when i open that code in 2005 it pops up conversion wizard..
it convert successfully .
but when i build it gives error
is something is missing ?
it gives error in "Iterator" keyword?
On 24 Apr 2007 01:36:16 -0700, p2 <firstname.lastname@example.org> wrote:
>i have code build in visual studio 2002 .
>when i open that code in 2005 it pops up conversion wizard..
>it convert successfully .
>but when i build it gives error
>is something is missing ?
>it gives error in "It...How to view 2 Excel worksheets from different workbooks same time
I have two monitors. I would like to open and view 2 different worksheets
from 2 different workbooks at the same time. Is this possible with Excel?
I would open excel (a single instance).
Then use File|open to open both workbooks.
Then I'd look at Chip Pearson's notes:
> I have two monitors. I would like to open and view 2 different worksheets
> from 2 different workbooks at the same time. Is this possible with Excel?
i have 3 monitors an i usually open 3 instances of e...Sum Values depending on other values
I would like to have a formula in a single cell that will sum the values in
range E:E if the corresponding value in G:G is >0.
Col G Col E
The sum of Col E is 4.
(remove nothere from email address if mailing direct)
"bw" <email@example.com> wrote in message
> I would like to have a formula in a single cell that will sum the values
> range E:E if the c...Pre defined value in Text Box
I have input box that when certain criteria are met needs
a predefined value in a text box within the input box. I
have used the following code to try this but it doesn't
seem to work
Activity_Text.Text = "812402"
Job_No_Text.Text = ""
Rec_Point_Text.Text = ""
Activity_Text, Job_No_Text and Rec_Point_Text are the
named text boxes. When the input box opens the Activity
text box is empty!!!
Many thanks in advance
...Can we install Rollup 2 for CRM 1.2 Build v1.2.3297.0
We have a pending upgrade from version 1.2 to v3.0
I was thinking of istalling the rollup for ver 1.2 before upgrading to
The current build of the server is v1.2.3297.0
The link below suggests that the build #for rollup 2 1.02.3297.173
Has any body come up with issues when installing the rollup on the 1.2
server (build is 1.2.3297.0)
Or is it better to try and directly upgrade to 3.0 rather than putting the
roll up and then doing the upgrade?
If you are going to upgrade, then I would just ...Newbie question / plug in a value for a cell based on a range for that value
New to Excel so sorry if this explanation isn't the clearest in terms of
In one section of my spreadsheet I have a list of percentage values
associated with numbers 1-20. For example #10 is listed with the percentage
value of 38.4% in the cell next to it (O14 and P14).
In another section of the spreadsheet I have a quick formula that I'd like
to use these %'s based on what number (1-20) is entered.
In my spreadsheet the % I want to use for this #10 is listed in P14 (38.4%).
What can I plug into my formula so when I enter "10" is kno...Read values from excel rows
I am trying to read the values from a excel row. There are 89
columns for each row and same number of data in each rows.
You need to explain how/where you want to read them.... From another workbook, another worksheet, a
VBA function, a macro, a C# application?
MS Excel MVP
"shantanu" <firstname.lastname@example.org> wrote in message
> I am trying to read the values from a excel row. There are 89
> columns for each row and same number of da...count number of characters in rich edit control
How can i count number of characters in rich edit control 2
If u mean controls of type Rich TextBox control, try
"Rahul" <Rahul@discussions.microsoft.com> wrote in message
> How can i count number of characters in rich edit control 2
EM_GETTEXTLENGTHEX, WM_GETTEXTLENGTH, WM_GETTEXT, EM_STREAM*
"Rahul" <Rahul@discussions.microsoft.com> wrote in message
> How can i co...Multiply all query by same value
...getting rid of zero values in a column
i have a set of data on a column that i`ll use to plot on a graph and find a
trendline for its behaviour...problem is: there is zero values in some cells
that were not calculated... i want to copy this data in a new column getting
rid of cells with zero value because it results in a wrong trendline...how
can i do this?please help
this is an example of what i mean:
One of the simpler ways is to hide the rows for the cells that have zeros and
then plot the graph.
> i have a set of data on a ...Copy #2
I have a small problem but still need some help.
I have a workbook called "Sumary.xls" located in a folder
Dim strPath As String
Dim strParent As String
Dim pos As Long
Dim Slutt As String
strPath = ActiveWorkbook.Path
**** Then i have to open another workbook called "Statistikk.xls"
pos = InStrRev(strPath, "\")
strParent = Left(strPath, pos - 1)
Slutt = strParent & "\VT" & "\VT" & "\Arkiv\" & "Statistikk.xls"
***Everything is ok with this, but:
***** Then i want to...Track 1 and 2,Fullz,Skimmer,MSR
FULL CC with mmn,ssn,dob,pin = pm me for price
Atm Skimmer Wincor Nixdorf = 3000
Atm Skimmer Wincor = 3000
Atm Skimmer Slimm = 3000
Atm Skimmer Slim = 3000
Atm Skimmer NCR = 3000
Atm Skimmer Diebold Opteva = 2500
Atm Skimmer Diebold = 2000
Atm Skimmer Universal = 4000
Atm Skimmer Small = 2500
Chip POS ingenico&amigo = 1500
PRINTED TRACKS ON PLASTIC WITH PIN FOR SALE
YIM : email@example.com
ICQ : 37630432...