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...Error opening Excel File
I'm currently having these days an error while opening an
excel sheet. The sheet is shared among five users. When
one tries to open it, a message indicates that the file
is locked for editing by another user and after checking
with the user, I understand that he has already closed
the file but the latter remains locked. Can someone help?
...How do I open power point 1997 attachments with outlook 2000?
I have an attachment sent with Microsoft Power Point 1997, and when I click
it, I can't open it or save it. What and were do I get add-on to open it?
Outlook doesn't open Powerpoint files, you need a PowerPoint viewer
> I have an attachment sent with Microsoft Power Point 1997, and when I click
> it, I can't open it or save it. What and were do I get add-on to open it?
Are you not running Office Standard 2000? That comes with PowerPo...mail will not open
when trying to open some...not all...emails I get the message "there was an
error opening this message.....an error has occurred".
This doesn't happen to all messages nor does it happen to all messages from
the same sender.
"velona" <firstname.lastname@example.org> wrote in message
> when trying to open some...not all...emails I get the message "there was
> error opening this message.....an error has occurred".
> This doesn't happen to all messages nor doe...Opening a subfolder of %MyDocuments% using Shell explorer.exe
I was hoping that someone might be able to help me with a problem I am having opening Windows Explorer from a forms element.
The following code works fine:
Shell "explorer.exe / e, ""%MyDocuments%\"", vbNormalFocus"
However when I try to access a subdirectory of %MyDocuments% using the following, Windows Explorer just opens the root directory of my documents and ignores a subdirectory request.
Shell "explorer.exe / e, ""%MyDocuments%\SomeFolder"", vbNormalFocus"
Additionally when Explorer opens under either of the above it o...format question when open csv file
I receive a csv file that I open in excel. The first field in this file is a
nine alphanumeric character. When I open the file excel formats that field
in how it sees fit. Example 1157687E6 would display in scientific notation.
I make a quick update to the file and resave as .csv file. The csv file
resaves that field as the scientific notation, so the people I pass this file
to have problems with it. Is there a way to open a csv file in excel where
excel does not reformat the field or give me an option to not reformat.
>> Is there a way to open a csv file in excel where exc...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.
...How can macro open daily generated files?
please can anybody help me with xls macro? I receive on daily basis txt
files with name that contains actual date. Typically "Data_20100120.txt". I
want to use macro, open files, modify data and add them to another workbook.
That's no problem, but I don't know, how to daily open files with different
I am not sure, how can I modify open sentence.....
Many many thanks for your help.
Give this a try:
myDate = Format(Date, "yyyymmdd")
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...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...Openning Grouped Columns in Protected Sheets
We want to put such a protection to the sheet that, the
protection will not prevent the user from openning
This is possible only through a macro, for example:
.EnableOutlining = True
.Protect , True, True, True, True
This setting does not get saved with the workbook, so it must be reset by
running this macro each time the workbook is opened.
...How do I open Excel 4.0 files in Office 2000?
I have Excel files with Macros, originally saved in Ver 4.0 (Office 97). Now
running Office 2000 professional and when I try to open these files I just
get a security warning and the files won't open.
have you tried setting the security level to 'Medium' ('Tools - Macros -
> I have Excel files with Macros, originally saved in Ver 4.0 (Office 97). Now
> running Office 2000 professional and when I try to open these files I just
> get a security warning and the files won't open.
...Can not open
Know very little about this but I want to open a PUB file from a floppy
from our churches pc on mine but it tells me I have the wrong version. Both
PC,s have Office 2002 with PUB on them why can I not open it?
But, which versions of Publisher do you have on each? You need to verify the
versions as well as let us know if either system is running Norton
Microsoft Office Publisher MVP
Official Publisher MVP Site:
This posting is provided "AS IS" with no warranties, and
confers no rights.
"Tom" <ttyso...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...Line count
I am working with a program called Dictaphone. We use Word 2007 in this
program. The line count on Dictaphone and the line count in Word 2007 are
different even though the Dictaphone text is retrieved from Word 2007. Why
would they be different?
What is the difference between virutal line count and physical line count?
...Can not open outlook 2007
I have outlook 2007 and i went to check if i had some emails this morning,
once i checked if i did, i closed outlook down.
I came to check again tonight and outlook will not open. I have done a
repair but it still doesn't work and i also uninstalled office 2007 and
reinstalled office but still the same.
Is there anything else i can do to get outlook 2007 to work??
I have the same problem and it also started yesterday.
> I have outlook 2007 and i went to check if i had some emails this morn...Author of Excel workbook appear in footer
Is there a way/code to have the author of the excel file
appear automatically in the custom header/footer of an
Excel 97 file. Maybe some type of code. Any help would
be greatly appreciated.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In ActiveWindow.SelectedSheets
wkSht.PageSetup.RightFooter = ActiveWorkbook.BuiltinDocumentProperties("Author")
You must place it in the Thisworkbook module
When you print it will add the name in the footer
Right click on the Excel icon next to File in the men...Counting sales
I have two different datasets. Each with a common identifier. I need a
formula that will reference the identifiers in both datasets and count the
number of sales a particular agent made. Example. look up this identifier
in the other dataset and then give me the value that is 2 columns over from
the identifier in the second dataset.
See if this helps:
Microsoft Excel MVP
"Dave" <Dave@discussions.microsoft.com> wrote in message
>I have two...Trying to open a blank document
Every time I open Word a particular document opens with it. I seem to be
unable to open a blank document. I deleted the document that appears every
time I open Word and still that same document is there when I open Word and
/or a new blank page on Word. Any advice on how to correct this?
Microsoft Word MVP
"Chairlady1" <Chairlady1@discussions.microsoft.com> wrote in message
> Every time I open Word a particular docum...Linking workbooks: links not live
Hi, all. I'd appreciate your comments on w
I keep one detailed master matrix in Excel 2007 for some documentation, to
track my workflow. I created a second workbook to give managers a less
detailed view, by hiding columns, saving the new workbook with a new name,
and linking the master and the quickview.
For reasons I don't fully understand, I can't Enable This Content to
automatically update links, and not all the links have been working. When I
repeated the process, the links appeared in the quickview, but were not live.
I checked, and there was a 1:1 match ...Counting Cells with Conditional Formatting
Is there a way to look at a row of data that is either highlighted yellow or
red and to count only the data that is highlighted yellow and give me that
None of my data is numerical....just one letter data, i.e.: "S" or "U"
I just want to count how many of the cells are highlighted yellow in a
specific row, if that makes more sense.
Here's a UDF (Put in a Standard module)
and use it in cell A1, like =CountByColor(A8:H8,6) << where 6 (at
present) = Yellow = change to =CountByColor(A8:H8,3) to get the reds
Function CountByColor(InRa...COUNT ? need formula
I want to track the results of my teams sales performance.
I record if it is a sale, no sale, cancelled etc in column M. I thought I'd
be able to use the COUNT function/formula to be able to search for all the
SALES in column M and place the result in a cell ( column O )but I can't
work it out.
"Diamond Jones" <kwanzaNOSPAM@optusnet.com.au> wrote in message
> I want to track the results of my teams sales perf...Outlook takes forever to open
Outlook opens half way, then I get an error message.
Sometimes taking upto 10 minutes.
I am creating a report for the number of pupils being collected at a certain
collection time e.g. 14:00hr and 15:00hrs
using the formula =Count([Child Last Name]) in the collection time footer
However when i try to count the overall number of pupils in the footer using
the same formula, 'Error' appears on screen?
There are potentially a dozen footer sections in a report. Which one is
giving you a problem? What is the name of the control? What is the exact
Microsoft Access MVP
> I am creating a r...Counting a count
How do I count a count??
This is what im trying to do:
I have a database with a table named tblMain and has incorporated everything
within that table but contains info from about 8 other tables. I have not
doesigned this database and it appears to have a very poor structure...anyway
There are three fields involved in this process...'Request' (either
'dispensation', 'waiver' or 'dispensation and waiver'), 'Department' (which
consists of 7 other drop down menu options) and 'RequestStatus' which
contains the status of each request by another...