how do i count numbers that contain 02 (i.e.7029955)?
how do i count numbers that contain 02 (i.e.7029955)? I tried
=COUNTIF(C143:C154,"?02????") but it did not work. The system seems not to
recognize the ? wildcard.
GMT+8, 1� 22' N 103� 45' E
"caliche" <firstname.lastname@example.org> wrote in message
> how do i count numbers that contain 02 (i.e.7029955)? I tried
> =COUNTIF(C143:C154,"?02????") but...Counting with multiple criteria
Would be grateful if someone can help me with this
A B C D
1 CA03 ON CA03 OF
2 CA03 OF CA03 OF
3 CA03 ON CA03 TR
4 CA03 TR CA03 TR
5 CA05 OF CA04 OF
6 CA05 TR CA05 ON
7 CA04 OF CA05 TR
Note: Column A-B has the same header row, and so does C-D
I want to count in the range (A1:D7)
- How many CA03 and TR: [the result should be 3]
- How many CA03 and ON and OF: [the result should be 5]
Thanks in advance for your help.
Assuming your table is in A1:D8,
data in rows 2 to 8 (in A2:D8)
> ...Read Receipts #4
How do I turn off read receipts? I would like to insure the sender does not
know if I read the email sent to me.
Thx in advance
You could either swich it off globally in your exchange settings or use
tools like aloaha to remove the delivery/read receitpt requests from
"rgm" <email@example.com> schrieb im Newsbeitrag
> How do I turn off read receipts? I would like to insure the sender does
> know if I read the email sent to me.
> Thx in advance
How do you switch i...Report available for items IN a stock count?
Is there any report already built in to Dynamics that will show us a
particular vendor's items that are currently in a stock cycle count? Or show
us if it's ever BEEN in a stock count (other than annual inventory)
Is there something in SmartList?
We are using v9.0
I could create one via MS Access if someone could tell me which tables would
be the ones to use?
IV00103 - Item Vendor Master
IV10300 - Unposted Stock Count (header)
IV10301 - Unposted Stock Count (line detail)
IV30700 - Stock Count History (header)
IV...OST file #4
I deleted my Exchange mail account because the corporate
exchange server harddrive crashed and I now need access
to my outlook.ost file. I have tried Norton and "recover
my files" with no success. Does anyone have any
suggestions on how to recover the .ost which is 400 MB?
Thank you for your time. - Mark Adkins
Fixing this problem is critical to my employment. Can
anyone direct me to someone who may be able to help?
>I deleted my Exchange mail account because the corporate
>exchange server harddrive crashed and I now need access
>to m...How to move our data from Online CRM 4.0 to On Premise 4.0
We have been evaluating the on line version of Microsoft Dynamics CRM 4.0
for almost a month. The 12 employees who were selected for the test period
spent many hours on uploading their contacts and calendar to the online
website. Now we decided to use the on premise version and need to export all
the data out to the online account and import to on premise.
I was wondering if anyone can direct me to a document or any kind of
resources that explains the process.
I was wondering about this too a few months ago. There are tools available
for moving fro...page numbering #4
As usual, I am having a difficult time doing a simple
task in MS Office. In Publisher 2002, how do you start
page numbering on a page other than page 1? This is easy
to do in Word (start page numbering on page __) and
troublesome in Publisher 2000 (tools>options menu), but
in Publisher 2002 I have not been able to find any help
on how to do this. How do I start numbering with "1" on
say, page 6?
I am replying to my own question, in case any one else
needs the answer! Go to "insert>section" and figure it
our from there (like I did). Oh and probably look forw...VBA Question #4
I have BASIC programming skills but have never had the opportunity to
use VBA inside Excel.
Using a UDF, I need to know how to take the contents of a cell and
pass it to a variable inside my user defined function.
I am trying to take the results in one cell and if it matches, then
take the information from two other cells and multiply them together.
I've poured over the VBA documentation and see how to push a value
into a cell, but can't find any examples of retrieving a cell's
Thanks in advance!
Independent AMSOIL Dealer
AMSOIL - The "...Help with count formula please,
I am using this formula as part of a spreadsheet I am using for a social
golf club, it has 20 sheets, and this formula keeps track of how many games
an individual plays. It works well except for the fact if a player misses a
game the result (in C35 shows 0, as per the formula)
eg: c7 1 c8 2 c9 3 c10 4 and the result in c35 is 4 ( as I want)
but if c7 1 c8 2 c9 (no input,blank) c10 3 the result in c35 is 0 not 3
So what I need is to change the ,0) bit but I am not sure what with or how
to replace it so that it ignores a blank cell .........
Thanks for any help
Ke...Counting spefic cell (not a range) with a value greater than 1
I am looking for a formula to count specific cells and a range (A5, A10, A15,
A20 and so on) but only count when the value is greater than $1.00. So if
the value of cell A5 was $1.50, the value of cell A10 was $1.25, the value of
cell A15 was $0.50 and the value of cell A20 was $2.00 the total count would
be 3. I'm stumped!
however if you want to sum every 5th cell greater than 1 you can use
Peo Sjoblo...Does CRM 4.0 work well with Office 2003?
We're looking at upgrading from CRM 3 to 4.0. Most of our users are at
MS Office 2003 and we'd like to keep that way for now. I understand
4.0 is supposed to be "compatible" with MS Office 2003 but I've been
researching the issues.
Are there any known compatibility issues between CRM 4.0 and MS Office
2003? Will using 2003 instead of 2007 cause any loss of functionality
in CRM? (Such as disabling the tracking token.)
Both Outlook 2003 and 2007 works fine with Microsoft CRM 4.0.
We have a mix of Outlook versions being used everyday for the l...Count consecutive cells
I have a table which tracks the attendance at an event over the years. Each
time someone attends, I enter 1 in the column for that year, otherwise
blank. I'd like to know the most consecutive events people have attended.
So, if I have rows like (with 'b' representing a blank cell):
Name1 b 1 1 1 b 1 1 1 1 b 1 b 1, most consecutive = 4
Name2 1 1 b b 1 b b b b 1 b 1 1, most consecutive = 2
Name3 1 1 1 1 1 1 b 1 1 1 1 b 1, most consecutive = 6
Name4 1 1 1 1 1 1 1 1 1 b 1 1 1, most consecutive = 9
Name5 b b b b b b 1 b 1 b 1 b b, most consecutive = 1
Is there a formula I can use to c...Count by short date and group by agent name
I have a tracking table (tbl_Tracker) that now contains date and time in one
field [Date] and agent name in another field [SLR]. I would like run a query
to do a count of number of records by agent by day. How do I set up the query
to recognize only the date and not the time.
I have Group By [SLR], Count [SLR] and Group By [Date], however it shows a
record for each date and specific time instead of grouping the whole day.
Then I need to build another query that looks at another table
(tbl_SL_Call_Stats) for number of calls handled [Handled] by day [Date] for a
date range and ...Advice on Install 4.0 please
I just finished installing a new Server 2008 AD DC for installing MS CRM 4.0.
My question is please. Do I need Exchange to do this or can I use another
Also what OU should this application run in?
I double posted this sorry. I made a mistake and posted in the wrong place.
CRM does not require Exchange. 4.0's email router can be setup to use any
SMTP/POP3 mail server. The OU does not matter either.
MVP - Dynamics CRM
"Joe" <Joe@discussions.microsoft.com> wrote in message
I am trying to do the following:
1. Count populated Rows using VB
2. If the # of populated rows is less than 2 post a message box dsiplaying
3. If the # of populated rows is greater than 3, continue on with the rest
of the macro.
Anything you can do to hlep is greatly appreciated.
This will look at the last populated cell in the desired row.
mc = 2 '"a"
x = Cells(Rows.Count, mc).End(xlUp).Row
If x < 2 Then
MsgBox "Only " & x
MsgBox "oh boy"
Microsoft MVP Excel
S...Filter Count question
I have the following code:
.Filter = "[Status] = 'Open' AND [Source] <> 'SE Meeting'"
.FilterOn = True
Me.Label32.Caption = "PCCB Action Items"
.OrderBy = "[Group_Name], [IssueID]"
.OrderByOn = True
When I execute this on a commandbutton it returns all the open action items
not equal to SE Meeting as the source code. That works perfectly.
I have a new unbound textbox called AI_Open. Once I execute the above code,
i want some code that will count the number of open action i...Column Headers #4
My column headers have changed to numbers instead of letters, and Im finding it impossible to check my formulas
I cant find how to change it back
Go to the Tools menu, choose Options, then the General tab. There, uncheck
the "R1C1 reference style" setting.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Kevin Depree" <firstname.lastname@example.org> wrote in message
> My column headers have changed to numbers instead o...Trying to freeze 1 column; keeps freezing 4 columns !?!
I am trying to freeze my "A" column. I select the "A" column, the click
Windows/Freeze and it freezes columns A-D!
What am I doing wrong?
Click on Col B and then do Freeze Panes. It will freeze everything to the left
and above what is selected, so if you only selected a single cell, say B2, it
will freeze column A and row 1 as well.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
Attitude ...If statement to export query if record count is not null
Greetings, thank you very much to all who are reading this. Basically I have
an automated email that goes out every Monday. Very simply it uses
sendobject to email a query. I would like to add some logic that basically
looks at the record count and if it isn't null...sends teh email as is...if
the record count is empty I would like to have it send an email that
basically says "The record set this week is empty."
Below is the module converted from the original macro. I was having trouble
modifying the module so any help would be greatly appreciated. Thanks in
...Outlook express identities #4
I deleted an account from Outlook express because
the "identities" were not "managing" properly, now I need
an email that was in a folder in that account. Is it gone
Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum.
Outlook Express is family of Internet Explorer and Outlook of the Office
Here is the link for the right forum
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Backup and Restore
Hi All -
Im receiving a "Server was unable to process request." error when the
following line of code executes:
Dim accounts As BusinessEntityCollection =
Any idea on why this occurs. The error is very vague, and does not
contain an inner exception. Thanks for shedding light on this if you
Try checking the Details property on the SoapException this will give you the
actual error. Otherwise turn on tracing on CRM this will log the same
Patrick Verbeeten (MCPD)
Tools for CRM Developers and...Importing data #4
I'm building a datbase using Filemaker Pro for Macs. I can import data
from an Excel spreadsheet into the datbase pretty seamlessly. I would
like to send out an excel template and have people fill in the needed
data (names, phone numbers etc.) I would like to merge all this info
into one excel spreadsheet and then import it into my database. My
question is what is the easiest way to merge all the separate excel
documents (@400) into one document.
ATC18's Profile: http://www.excelfo...Printing columns #4
I was sent a spreadsheet that is only 38 rows long, but goes from column A to
DA. Is there a way to "stack" the columns to print? For example, pon page one
I want column a thru e stacked on top of columns f thru j stacked on top of k
thru o and so on.......
...CRM 4 Phone Call Report
I am putting together a report on Phone Calls. I would like for the report
to show the owner, activity status, modified on, account and notes associated
with the phone call. I have figured out everything except the Account
portion. When I created it orginally, I set the column properties as
Regarding (Account). This however, only showed the Account if the phone
calls regarding field was regarding an account. Some phone calls are
regarding a marketing list, campaign, etc. I would think the way to do it
would to have the column set to show the recipient, but I can not find this
opt...Dynamics CRM 4.0, how to undo (or revert) customization?
We made a bunch of customizations to the Opportunity entity forms &
views, based on a poor understanding of how this entity is to be
used. I would now like to put it back to the way it was when the
software was installed. Any way to do this without reinstalling? We
have a lot of other customizations and data we want to preserve.
Thanks for any help.
Did you do an export of the 'vanilla' customizations after the initial
"Ed Cayce" <email@example.com> wrote in message