User Defined Function
How would I write a MinIf function that could be used in the spreadshee
in the same way the "CountIf" function is used.
It would be great to be able to min a range, selecting all values abov
Any thoughts greatly appreciated
Message posted from http://www.ExcelForum.com
Try something like:
In B1: =MIN(IF(A1:A100>0,A1:A100))
Array-enter with CTRL+SHIFT+ENTER
(instead of just ENTER)
Please respond in thread
"dovrox >" <<firstname.lastname@example.org> wrote in message
news:...formula help #4
I could use some help in creating a statement that avoids the div/
error in the following formula
at any point G4,L4,Q4 could be a value of 0. G40,J40,J42,G41,J4
always have values.
I'd like the cell to show a value of 0 when there are not any value
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
Hi, I'm needing to adjust the height of the cell but the measurement is in
pixels, can I change it to inches? Mindy
"Mindy" <Mindy@discussions.microsoft.com> wrote in message
> Hi, I'm needing to adjust the height of the cell but the measurement is
> pixels, can I change it to inches? Mindy
Note that row heights are measured in points, there are 72 points to the
pixels are video card dependent (resolution etc)
R...Pivot Table help #4
I have a list of data with the following columns (Location, Item #, Late,
Late if not rec'd today, Late if not shipped today). The last three have an
"x" to indicate status and there are several blanks. I created a pivot table
that had Location in the Page field and Count if Late, Count if Late if not
rec'd today, Count if not shipped today in the data field. My pivot table is
accurate but when I double click on a total for say Late, I get a full list
of all items for that location, not just the late. I tried putting location
in the Row field but got the same resul...arrow keys #4
Did a search of your posted messages - yes, he had his
scroll lock key on!!. Thanks, you guys are great.
...Error "propagating language setting" when starting CRM 4 for outlo
I have a new installation of CRM 4. My webclient works fine. When I install
the client for outlook on my outlook 2003 the installation passes without any
problem. I then go throug the configuration without any problems. When I
start outlook it is stucked on "propagating language setting". I have tried
on four different clients with the same result. Any idea???
I have the same issue at the moment. I will post here if I figure it out.
Please do the same if you do.
> I have a new installation of CRM 4. My webclient works fine. When I i...Address Lists #4
This is a multi-part message in MIME format.
Does anyone know of a solution (MS, script or 3rd Party) to get the =
5000+ external contacts I have in public folders into an address list? =
I know how to set that up on clients to display the public folder. Some =
people need access to 5 or so different PF and we are looking at various =
CRM solutions that would created more nested public folder contact =
lists... just looking for another solutions...office 2004 (excel & word) afp file path issue on tiger server (10.4.9) #2
we have just changed over to an xserve (running 10.4.9, HFS+ with
ACLs) and are experiencing the following problem with office 2004
excel & word files only - surprisingly powerpoint files are not
all excel and word files without spaces in either file- path or -name
open just fine, however all files with spaces in file-path or -name
generate the following error message...
alt="excel error message" />
for the above we used the following example file:
-rwxr--r-- 1 daniel...prompt for function arguments?
I have a macro that calls a function with 2 arguments:
Import (file path, state)
This function is importing excel files into an access database. I
have to import a file for all 50 states. Is there a way to set
something up that when the code is run, it will prompt for the file
path and state?
Thanks in advance for any help.
You can base your path and state off unbound fields on a form so that those
fields would need to be populated before running the code.
If the paths stay the same for each state, it sounds though like you might
want to make a table to store the path and state and...SumIF function #12
I apologize for not making myself clear. I appreciated the response. And
allow me to qualify my original question further. I know I can do a pivot
table and obtain the results, but I am trying to avoid that.
See my example below - the question is how do I do a sumif function within
a summary view when I want to recap hundreds of rows by alpha FERC Codes and
sum associated values within the aging bucket column? I included an excerpt
of 5 records under 4 column headings, and then I show the summary of those
five records below by FERC Code by aging bucket. The countif function work...CRM 4.0 Knowledgebase fields
I'm attempting to dump out the fields from the Knowledgebase section of the
CRM to eventually use them for our customer knowledgebase on our web site,
but am having a difficult time handling one of the fields. The field in
question is called "articlexml" and if I dump them out via SQL, it contains
what appears to be some xml related data. ...I'm not good enough at my
parsing skills to remove it, so I was wondering if anyone had any insight to
Here is a sample of one of the entries in that filed (some content removed
<articl...CRM 4.0 - Word 2007 - mail merge
OK, so I've read a number of blogs detailing the mail merge process.
Open in Word, save as XML, import to CRM, edit and add the mail merge
fields. Simple, right?
My organization has about a dozen mail merge templates which worked
very well in CRM 3.0. I was fully aware I would probably have better
luck just re-creating them in CRM 4.0. No biggie.
I've done so and mail merge in CRM 4.0 is ... shall we say less than
Mail merge on the Contact entity does not work at all. For any user.
Mail merge on the Account and Opp entities works sporadically.
Literally from one user to th...Quartile Function
I would like to use a formula to return which quartile the given data array
falls into- that is I would like to return 0,1,2,3,4. 0= min, 1=25%, 2=50%,
The quartile function only returns the value of the various quartiles, while
I need to know within which quartile the value falls.
Any help is appreciated.
On Tue, 15 Mar 2005 01:01:02 -0800, "tika528"
>I would like to use a formula to return which quartile the given data array
>falls into- that is I would like to return 0,1,2,3,4. 0= min, 1=25%, 2=50%,
&g...CRM 4.0 VPC Problem
I downloaded CRM 4.0 VPC, extracted them, and I got MSDYCRM40VPC_BASE.vhd.
After I create a new virtual machine for this vhd, I got an message "Reboot
and Select proper Boot device or Insert Boot Media in selected Boot device"
when I clicked Start. So, it have not brought me to WINDOW LOGIN SCREEN.
Anyone had this CRM 4.0 VPC worked, please help me how to get it work to get
away from a message above.
Thanks and Appreciations
"Toi Day" <ToiDay@discussions.microsoft.com> wrote in message
> I...sumif using the now() function
I am trying to sum numbers using the NOW() function as my criteria, however
sumif($D$1:$BC$1. ">=NOW()", D2:BC2) Any help would be appreciated.
Assuming you try to sum D2 to BC2 on your example.
renegan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1045
View this thread: http://www.excelforum.com/showthread.php?threadid=52871
renegan: Thanks for your response, however I got #VAL...On-Premise - Outlook CRM Client 4
We're having a multitude of issues with our CRM for Outlook Client. These
issues have just started accross multiple users since CRM was installed last
1)Many machines running Outlook 2003 / 2007; current patches with the
Microsoft CRM4 (RU5)Outlook client installed.
When creating or replying to a HTML, or RTF, e-mail sometimes even though
the cursor is in the body text area, the formating toolbar will be greyed out
(as if it
is a plain text e-mail) unless the user right clicks in the toolbar area of
the message which apart from bringing up the toolbar customization menu
...Dynamic change of worksheet reference in a Hlookup function
I am a basic user of MS Excel, and starting to use hlookup function.
In this function i have the worksheet reference that i want to change
linked with a cell in another worksheet.
- Want to change '02545' for the cell "Info!$D$11" which has th
worksheet reference, that i can change for another worksheet within th
Thanks for the hel
fariapedro's Profile: http://www.excelforum.com/member.php?a...Public Folder Replication error #4
We have windows 2000 domain, exchange 20003 running on windows 2003 member
server, we have to windows 2000 sites, all AD replication is OK, but only
public folder replication did not happen, between two servers,
I am getting following NT event application event error
EVENT ID 3093
Error -1603 reading property 0x36010003 on object type tbtFolder from
database "First Storage Group\Public Folder Store
Also I have following event 3085
Error 0x8004010f occurred while generating an outgoing replication message.
Database "First Storage Group\Pub...Inability to design functional reports or workflow processes
Standard across the board everyone must want the following capabilities
To create a Report whereby
All Accounts with no Activities past 2 months can be shown
All Accounts with no Opportunities past 6 months can be shown
Is there a possibility of including this in a View? (Optimal)
Is there any possibility of creating a report with c360? (Workable)
At the weekly sales meetings Division Management wants to not only go over
the positive but also the negative such as which major Accounts have gone
without activity and need to be reassigned to other Salespersons.
Chuck: I have tried everything t...Business Portal installation error #4
I am installing business portal (for gp ver 10.0) dynamics db and company db
are upgraded from 8 to 10. when I am installing BP an error mesage coming
and BPSQLlog files shows :
"Database: "n/a" Actor: "SQL.VBS_LoadSQLComponent()" */
ERROR: Path (C:\Program Files\Microsoft Dynamics\Business
Portal\Utilities\SQL\Upgrade\2.5.1173.0\System\GP_COMMON\) did not exist."
and continue installation and will finish sucessfullly. But portal gives
Please help me!
One more error is
"Failed Loading Packager Data Element (PD_GP_COMMON) for Inst...using color for if function
Operating System: Mac OS X 10.5 (Leopard)
For instance, I would like to make the sheet operate so as, <br><br>If a number is positive, it is black <br>
If a number is negative, it is red <br><br>instead of manually changing the color of each negative number
On 3/4/10 11:24 AM, email@example.com wrote:
> Version: 2008 Operating System: Mac OS X 10.5 (Leopard) For instance, I
> would like to make the sheet operate so as,
> If a number is positive, it is black
> If a number is negative, it is red
> i...NZ Function and Null VS 0 values
Here is my question, I have the following statment in a query:
This returns either the number of the addition or 0. The problem is
that I have NULL values in the table, where 0 would represent that yes
nothing was done and Null would represent that nothing was support to
happen. What I need help with is trying to add the needed columns if
they have a value >...Product Key #4
I have a problem. I am working on a poster for a presentation, and someone
suggested that I use Publisher. I tried to launch, but it is asking for my
Product Key. I am working on my work computer, and it was here when I got here,
so I don't know the product key. How can I find this? My IT guy says he
doesn't have it.
If it's Publisher 2000 or older you're up the creek without a paddle. But if
it's a later version of Publisher I believe BelArc Advisor will show it to
you. For Publisher 2000 (the version I use) the Product Key looks similar
to a Windows ProductKey, 5 ...If-Then Statement #4
Column A = Part Used (not needed for this part)
Column B = Weight of Item
Column C = Company Used (I found this using If-Then, an easy one..)
Column D = Price Paid
Column D is what I am trying to figure out.... what price they pai
according to the weight of the item.
So if the weight was 5 pounds, they used Quick Freight and paid $3.
If the weight was 10-50 pounds, they used Quick Freight and paid $20.
If the weight was 51-70 pounds, they used Gamecock Freight and pai
If the weight was 71-90 pounds, they used Gamecock Freight and pai
So for Column D, all the answers will eith...DEFAULT FONT #4
Referring to my previous message and just working on this
now, I have discovered that if I create a template with
the font style I want, I can use this instead of the
normal template that comes up automatically on opening
Publisher. It does mean always going to FILE/NEW/Templates
but at least I can make it work.
Would be grateful to hear if anyone else has any better