Autofilter on Dates problem
I have an autofiltered table containing a column of dates with number format
dd/mm/yyyy. The entries are populated by "pick from list" data validation.
Several of the entries in this column appear as 05/04/2003 and further
research shows that they have numerical value 37716.
If I autofilter on this field setting criteria to:
Equal to: 37716
then all rows disappear ... no matches found.
If I autofilter setting criteria to:
Equal to: 05/04/2003
then the predicted rows reappear.
If I autofilter setting the criteria to:
Greater than or equal to: 37716
Less than or equal t...Show a range in a shape/picture object
I know I have done this before, but I cant remember how I got there...
I have a range of cells that need to be shown below another range of cells.
The Range of cells that will be shown in the shape/pic have rows and columns
that are of a different size than the ones that it will be placed on. This
is so that I can print one page landscape showing the main range and then 3
smaller ranges below.
The alternate range is diagonally down to the right of the main range so the
rows and columns can be sized to properly display the headings and allow the
correct width to show the da...TimeScaleData method in MOPS?
I'm trying to convert an existing mpp file, with its associated macros, into
something that can be done on Project Server. So far, I've managed to create
all the fields that were done via macros into custom fields on the server.
The one thing I'm left with is where the author of this file used the
TimeScaleData method to calculate a custom field for BQWS.
Is it possible to have an enterprise custom field that does this same
calculation? It's essentially the sum of hours between the baseline start
date and the status date.
I should note, Andrew hel...Fallen into a range
My problem is how to compute how many times a number falls into the range.
For example we have ranges:
12 - 20
15 - 40
How many times falls "13" into above ranges?
Thanks for help!!!
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.797 / Virus Database: 541 - Release Date: 2004-11-15
What excatly do your "ranges represent"? A group of cells? If not, I'm not
sure I understand how 13 could fall into 15-40.
If you want to count occurrences of the number 13 in a range of cells:
=countif(your_ran...Accessing Document class from CPropertySheet
How do I access the document from a Property Sheet/Property Page or Dialog?
> How do I access the document from a Property Sheet/Property Page or
Pass document's pointer in your property sheet class's constructor.
Kobi Ben Tzvi
"William Gower" <firstname.lastname@example.org> wrote in message
> How do I access the document from a Property Sheet/Property Page or
The update has now failed 12 times. Error code is - 0x80070005 - Can anyone
> The update has now failed 12 times. Error code is - 0x80070005 - Can anyone
0x80070005 is an Access Denied error.
Which edition of Windows ... what Service Pack level ?
How to ask a question
Read the above and then post back here with relevant information so that
someone *may* assist you.
"Security updates should *ne...How to Match and Sort two range of data?
Appreciate if anyone could help out on this issue. I have a range of datas
on sheet 1 and another range of data on sheet 2. Sample as below :
In sheet 1,
Company Name Sales Fig.
D Limited 4000
A Limited 1000
E Limited 5000
B Limited 2000
C Limited 3000
In sheet 2,
Company Name Sales Fig.
E Limited 5000
D Limited 4000
C Limited 300...CWnd derived class and keyboard shortcuts
I have created a new class to do some special editing, which I derived
from CWnd. In OnInitDialog() I create an instance of this class using
the following code:
m_Edit.Create (0, "", WS_CHILD | WS_TABSTOP | WS_VISIBLE, R, this, 0);
Additionally, my dialog has a cancel button with the label "&Cancel".
When I now press the C button in my edit control, this activates the
cancel button as if I pressed Alt-C. Is there any way to stop this
"Hartmut" <email@example.com> wrote in message
news:115...SUMPRODUCT with date range
I need help with a sumproduct formula that will sum with three difference
types of criteria and also use a date range? Any suggestions?
Give us some specific details. What are the ranges and what are the criteria
and what range needs to be summed?
Microsoft Excel MVP
"NMK" <NMK@discussions.microsoft.com> wrote in message
>I need help with a sumproduct formula that will sum with three difference
> types of criteria and also use a date range? Any sugges...Transfer Spreadsheet Method
I'm transferring data to an Excel spreadsheet, and I only want the Excel
column labels (A, B, C...) to appear as labels. I can't seem to suppress the
mdb column labels from the table.
Export the data from a query instead of a table using only the fields you
want in your spreadsheet export.
> I'm transferring data to an Excel spreadsheet, and I only want the Excel
> column labels (A, B, C...) to appear as labels. I can't seem to suppress the
> mdb column labels from the table.
I wonder if anyone can help me please ?
Firstly, apologies if what I am asking for is not possible, or if it
has been asked before, but I've had a look, and can't seem to find it.
I have a spreadsheet which I distribute weekly to certain people.
It is basically a top level view of incidents, which shows the
Sheet Number 1 is :
Person - Count
Joe Bloggs - 42
Fred Bloggs - 12
And so on.
This shows me a summary of how many incidents per person have been
Sheet Number 2 is the actual raw data for that count, so it shows every
So in the above example, t...The best method for forumlas and charts???
I'm looking for suggestions on the best way to go about getting the
information I want to display in a chart. Depending on the response, I may
also need help implementing the suggestion. Here's what I want to do:
On Sheet3 I have a range of data, for example:
A B C D
20-Sep R Y G
21-Sep Y n/a R
22-Sep n/a G Y
23-Sep R R n/a
On Sheet7, I want to have 16 line graph charts that...Setup failed
we are trying to install Crm 1.2 italian on Small Business 2003 italian.
Before installing Crm we have the following prerequisites:
• Internet Information Services (IIS) installed and the services started.
• Windows Indexing Service started on the installation computer.
• Microsoft Message Queuing Service installed as a Message Queuing Server
• Active Directory® in native mode.
• Microsoft XML Core Services (MSXML) 4.0 installed.
• The SQL Server service and SQL Server Agent started on the SQL Server
We have also default web site and...Autofilter record count
When using autofilter in Excel most people receive a record count in the
lower left corner stating how many items were included in the filter (ex: 7
of 15). This feature does not work on my computer most of the time and it
does on my associates machines. We can't figure our why? Any assistance
would be appreciated.
When your list has many formulas, or if a cell in the list is changed
after a filter has been applied, the Status Bar may show "Filter Mode"
instead of a count of the visible records. You can use the Subtotal
function to count the visible rows.
The followin...Need Help convert text to actual cell range reference address
I have wrote up a function that returned text string "B1:B18". What
function can I use so this text string can be used as an actual cell
Specifically, I want to make =match(C1,[a function that returned
"B1:B18"],false) work, so that match can see "B1:B18" as actual cell
On Jun 6, 9:02 am, liang.yu...@gmail.com wrote:
> hi all
> I have wrote up a function that returned text string "B1:B18". What
> function can I use so this text string can be used as an actual cell
> range reference?
> Speci...Auto fill weekday range in header cells????
I want to create a function or formula that would create the following:
|7/26 - 7/30| 8/2 - 8/6| etc...
So, each cell would have in it the start and end dates of the weekdays in the week.
Is this possible?
- in cell A1 enter the first date of the first week you are interested
- in A2 enter the following formula
=TEXT($A$1+7*(COLUMN()-1),"M/D") & " - " &
and copy this to the right
"FrankBooth" <firstname.lastname@example.org> schrieb im ...Letter Writing Assistant needs additional employee ranges
Currently, letter writing assistant only allows selecting of ranges by
employee last name and employee ID. Larger employers would benefit from
having additional sorts, for example by department, position or location.
Patrick Anderson, SPHR
HR and Payroll Consultant
JAT Computer Consulting
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" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-...VBA Find Method problem
Been racking my brain on this one and I don't know why it
I'm using the Find method in my VBA query to find cells
that contain the value "Rank", then does an operation on
the cells below it. Then it moves to the next page and
does the same thing. Unfortunately, if there are two
cells with the value "Rank" on one page, the code will
only look at the first one, do the operation, then go to
the next page. This is the basic code. I've tried a For
Each... Next loop right above the find method, but can't
seem to get it to work. I...customer autofilter
I cannot get the custom auto filter "ends with" or "begins with" to work.
Whenever I use this criteria, it selects no data from my list (my list
contains numbers). For example, when I try to filter the "number" column in
the below list to select only data where the "number" ends with 3, I should
get one result (82003). But I don't; I get no data at all. Does anyone know
how to get this function to work?
AFAIK this works only for text values and not numbers.
Fran...Send message failed
I get "send message failed" when trying to directly email a .XML or .HTM file
from a program using an Access database in Windows 7 with Windows Live Mail
set as the default email program. I can directly send emails to a recipient,
the issue only lies when I try to directly email a file utilizing the above
"Main Street Software, Inc." <Main Street Software, Inc.@discussions.microsoft.com> wrote in message news:365B2AAE-5E81-4FE5-AEF6-290EBA62A377@microsoft.com...
> I get "send message failed" when trying to directly email a...MainFraime class not receiving middle button messages
Hi, I'm using VS 6.0, MFC SDI. I ran Spy++, and I found out that the
CMainFrame class does not receives the mouse messages, like RButtondown
or MButtonDown. How can I do to tell the CMainFrame class to receive
those messages? why it doesen't recives them?
thanks in advance
You can catch these message in the PreTranslateMessage of the frame window
BOOL CMainFrame::PreTranslateMessage(MSG* pMsg)
if (pMsg->message == WM_LBUTTONDOWN)
if (pMsg->message == WM_RBUTTONDOWN)
if (pMsg->message == WM_MBUTTONDOWN)
return CMDIFrameWnd::PreTranslateMes...Looking for code to define a range
I am looking for code that automatically defines/names a range which changes
each month. Also I need the code which identifies the location of the last
cell in the range.
Not knowing what your range looks like I'll assume you want a range starting
at A1 and going down to the last occupied cell in Column A. I'll also
assume you want to name this range "MyRange".
To define and name the range, use:
Range("A1", Range("A" & Rows.Count).End(xlUp)).Name = "MyRange"
The cell address of the last occupied cell in Column A is:
Range("A&qu...Simple Question about file open method.
I have a skeleton of an application
The FileOpen has not been implemented:
There is a message map in one class
// NOTE - the ClassWizard will add and remove mapping macros here.
// DO NOT EDIT what you see in these blocks of generated code!
// Standard file based document commands
// Standard print setup command
I have searched through this forum cannot find a solution to what I need so
here goes (or perhaps I have missed it).
I have a workbook containing 11 worksheets - one for each country with the
first worksheet containing a set of standard charts which are reused for each
country. I am currently manually amending the data range and selecting the
worksheet and highlighting the data for each country (so have to do this 10
times). The data is in the same location on each country worksheet so really
the only amendment is the worksheet name.
How do you recommend that I speed up t...AutoFilter May be Misbehaving
I have a worksheet, using 1845 rows and columns out to AB. We use the
AutoFilter command on the Data menu constantly, and are getting a strange
When the filter is applied, it shows the appropriate data, but hides all the
rows from 1845 down to 3606 and then displays the remaining from 3606 to
What I can not figure out is why are rows 1845 to 3606 being hidden. There
is nothing in them. To be sure of this, I selected all the rows from 1846 to
65536 and over to column IV and from the Edit menu, select Clear - Formats
and then Clear - All, to no avail.
What am I missin...