I need a formula to calculate 2-3 columns but skip a column if it has a zero
I'm building a Golf League spreadsheet and we want to calculate handicaps
starting with the second week (calculates 2 weeks) and then after the 3rd
week calculates every 3 weeks.
Columns B-S are the individual weeks scores for each golfer (golfers listed
by row 4-33), each column (b-s) has a formula which pulls the golfers score
from the input worksheet(weekly input) to this worksheet(scorecard).
Starting with Column V we are trying to have the running handicap for the
year which changes each week.
Column W is the first week handicap =AVERAGE(B4-36)*0.8 (this ones easy)
Column X is the se...Using Access form to assign values of variables in an Excel VBA program
I have created a VBA program for Ms Excel.But,to get desired results,
every time, I go into the code to change the values of variables.Is
there a way to get the values of variables stored in an Access table?
YOu need to do a search for ADO method (ActiveX Data Object). There
are plenty of example of code on the web. You need to add two
references in your VBA to use the method.
from VBA menu tools - References
1) Microsoft Access XX.X object library
2) Microsfot ActiveX Data Objects X.X library
Use the latest versio of the two libraries on your PC.
You will make a conn...non vba way to print non continuous ranges
Is there a non vba way to print non continous ranges on the one shee
Specifically, lets say I want to print data from columns A, B, C, G an
K down to row 35 in each column. Is there a way I can do that withou
manually making them continuous by cutting and pasting each range ont
a new sheet?
DavidObeid's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=223
View this thread: http://www.excelforum.com/showthread.php?threadid=27196
You can h...Selecting top five values from Pivot
I have a Pivot shows the supplier name and the qty supplied by them.
Now in another sheet, I have to show only the top 5 suppliers, who have
supplied highest qty.
Above data is displayed in Pivot. In another sheet, I require, only top
5 suppliers with highest qty supplied.
...HELP!!! How do you create a query crieria for multi values??
Hello all, please hyelp, its an emergency!!!
Need to create a query where one of the searches is male or female, how do I
allow user to enter both as the search options??
Also how do I convert tix boxes into a query criteria (e.g. serach for all
Thanks so much for your help
...Disable/Enable all controls on a form based on value of another control
What is the best to way to exclude a specific control (or controls)
from the following condition? (e.g., I would like to exclude SubjectID
and MRN from being Enabled or Disabled):
Dim Ctl As Control
On Error Resume Next
If IsNull(Me.SubjectID) OR IsNull(Me.MRN) Then
For Each Ctl In Me.Controls
Ctl.Enabled = False
For Each Ctl In Me.Controls
Ctl.Enabled = True
I'm using this to ensure that the user enters the SubjectID and MRN
*before* entering more data for the subject. By disabling all the...Using Outlook Address Book vice Windows address book
When I right click on an item as select sent to mail receipient it uses my
windows address book, vice my Outlook address book. Since I don't want to
update both how do I make it default to the Outlook book and contacts?
Work is victory. - Ralph Waldo Emerson
Open Internet Explorer and select Tools | Internet Options | Programs tab.
Set the contact list dropdown to Microsoft Outlook.
"Jeff Mu�iz" <email@example.com> wrote in message
> When I right click on an item as select sent to mail receipient it uses my ...Cell Number Format includeing other Cell Value
I needed to create some conditional number format - to say so...
Cell A1 content is "m2"
as I Enter in cell A2: "10" -> the output to cell A2 should be "10
Cell A1: "Dollars" -> A2: 200 -> shown "200 Dollars"...
and so on....
Is that possible in Excel? (don't know VBA - yet :DD)
Any help is appreciated!
How about just use a third cell:
=a2 & " " & a1
> I needed to create some conditional number format - to say so...
> M...Exchange 2003 Books
Hello. I have extensive Exchange 2000 experience.
Are there any books on Ex2003 worth getting?
Thanks to All!
Microsoft Exchange 2003 Unleashed (Sams) is the only book I found useful.
> Dear All,
> Hello. I have extensive Exchange 2000 experience.
> Are there any books on Ex2003 worth getting?
> Thanks to All!
replied in microsoft.public.certification
"Angel" <firstname.lastname@example.org...Visual Studio .NET 2003
I have two projects in a solution. I want to create a dependency of one
project on the other. I know to do this in vc++6.0 but unsure in .NET 2003.
One is a library and I would like the library to be linked with the program
in the other project(to whom the library is dependant)
got it , Project->dependencies is there.
"mfc" <email@example.com> wrote in message
> I have two projects in a solution. I want to create a dependency of one
> project on the other. I know to do this in vc++6.0 but unsure in .NET
> ...Check value range, then return spesific number?
I want to implement a function in my spreadsheet, that gives me this:
When I enter a number into a cell, another number shows in another cell, based upon the number first entered. A bit more spesific:
The idea is to calculate the number of instructors needed for a week end seminar. 1 participant requires 1 instructor. Same for 2 participants, and 3.
4, 5 and 6 participants requires 2 instructors. 7, 8 and 9 participants requires 3 instructors. And so on. For every 3 participant, we apply 1 instructor.
So, i.e. if I enter the number 5, i want the number 2 in the cell below.
I trie...Fixed Assets import using Integration Manager
I am having an issue whemn importing Fixed Assets. I have a simple file that
I was able to import in one environment, but not successful at another
environment. The issue that I am running into is I receive this error when
importing the asset using Integration Manager for version GP 10:
Error: Microsoft.Dynamics.GP.eConnect: Number = 8692 Stored Procedure
taCreateAssetID : Description = The UpdateIfExists parameter is set to 0
and you are attempting to integrate a record that already exists in the
I tried manually creating one asset and then running the import ...Visual Basic.net
I currently work in Finance and have been told that VB.net is a useful tool
for financial modeling which I want to learn. Any opinions on this?
"Mark" <Mark@discussions.microsoft.com> wrote in message
>I currently work in Finance and have been told that VB.net is a useful tool
> for financial modeling which I want to learn. Any opinions on this?
This group is for VB 6 and earlier; VB.Net is a substantially different
language. You need to ask in a group with "dotnet" i...Assigning a default value to a lookup.
I have a client that only has one unit of measure (Each) and would like to
have this value set at default when creating new quote and opportunity
products. I spent some time looking into this and have not determined how to
control lookups at all except clearing them.
Any suggestions would be appreciated.
It's documented in the CRM SDK:
Michael H�hne, Microsoft Dynamics CRM MVP
Custom Lookup Dialog: http://www.stunnw...eliminate future zeroes
How can I show only valid data to date and not future data not yet entered
and considered by Excel as zeroes
Future data cells should be empty.
If they contain formula then the result for empty data should be NA()
rather than "". Charts treat text values, which "" is, as zero.
NA() will only stop the data marker being plotted. The line will be
interpolated between valid data points. But as your future points will
not contain any valid points the line will stop.
> How can I show only valid data to date and not future data not yet enter...w98 to wxp (DD32101@Comcast.net)
I just set up my new version on WXP pro..I had w98 2nd
I am not able to find my old Outlook Express files..
How do I find, and get all of my old emails and notes to
the new OE. The adress book did migrate, but all of the
files are empty!?
> I just set up my new version on WXP pro..I had w98 2nd
> I am not able to find my old Outlook Express files..
> How do I find, and get all of my old emails and notes to
> the new OE. The adress book did migrate, but all of the
> files are empty!?
> Thanx JoAnne
> ...Check Book Formula
I'm a real green horn when it comes to excel, I've
searched the data base and am pretty baffled by some of
the questions...Wow....anyways, I feel kind of silly
asking as this is probably very simple. I just don't know
how i would go about setting up a check book style
spreadsheet. The last three colums would be Income,
Expense, Balance. I understand how to add or subtract,
what I don't know is how to I tell the spreadsheet to
SUBTRACT the expense to get the Balance or and ADD the
income to get the balance in each row. Do I have to type
a formula in each row to do ...Format a whole row based on value of one cell
I want to use conditional formatting to colour a whole row of cell
based on the value in column C.
I understand how conditional formatting works on the single cell yo
select, but I don't know how to change the format for multiple cell
based on the value of a single cell.
Message posted from http://www.ExcelForum.com
try the following as an example:
- select row 1
- goto 'format - Conditional Format'
- choose 'formula' and enter the following formula
- choose a format
> I want to u...Can Leading Zero Be Hidden?
I have a number field (double) where it would be nice if
Access didn't show a leading zero. Decimal Places is set to
"Auto", and that is good, except for the leading zero.
Format is currently blank. Access 2002.
On Tue, 23 Mar 2010 06:36:01 -0700, croy <firstname.lastname@example.org> wrote:
>I have a number field (double) where it would be nice if
>Access didn't show a leading zero. Decimal Places is set to
>"Auto", and that is good, except for the leading zero.
>Format is currently blank. Access 2002.
>cro...How to remove comma and decimals from a value
How can I remove comma's and decimal's from a value using a formula in a query?
Assuming Excel recognizes the data as numeric, just reformat it. Edit >
Cells, select the Number tab, choose 0 decimals and uncheck the separator box.
If there not recognized as numbers, you'd first want to convert them: type
a 0 in some random cell, copy it, select your data set and Edit > Paste
Special, select Values and Add, then click OK.
"Send Object Command - Two attachments" wrote:
> How can I remove comma's and decimal's from a valu...Sort order when using Contacts as Address Book?
When using Contacts as an Address Book, is there a way to change the
sort order without changing the Default Full Name order? Currently
when I select "To..." while composing a new message, Contacts are
sorted by first name. I'd like to sort them by last name. Thanks.
One of the most frequently asked questions (probably becuase it's one of the
most carefully hidden options):
Go to Tools > E-mail accounts > View or change existing directories or
address books > Outlook Address Book > Change. > Set your sort order there
[MVP-Out...In stock non movement report?
I need a report that i can define dates and looks at on hand and when the
last time it was sold. What I am trying to do is rid my inventory of items
that are not moving. So i dont just need to know what is sold but how many i
have in stock right now. I hope this makes sense.
There's a canned report that can do just that. Go to Reports | Items | Item
Quantity List. Put in the date range for Last Sold as a filter. Make sure
you select On-Hand quantity and Last Sold in your column list.
...Line chart zero values
I am trying to do a automated line chart that updates as
users input over the next 12 weeks... the chart is
consisting of 12 weeks on the x axis and % on the y.
The problem im having is the values in the table that the
chart is picking up from are formulas... but if the
formula result is zero or ""(blank) I want the line chart
to ignore it... rather than plot zero values making the
line drop when a nil value or blank... for rest of the
whole 12 weeks...?
week 1 = 10%
week 2 = 11%
week 3 =
I want the line to stop at week 2...? but because to work
out the % is a formula...Enable Combo box based on value in check box and list box....
I am working in Excel 2003
As a part of my worksheet titled "Worksheet" I am trying to enable
Combo boxes based on the value of a check box and the value in a list
There will be a total of 6 combo boxes on the Worksheet. The first
combo box that deals with the body of a book will by default enabled.
The second combo box will be set to appear disabled unless a forms
control check box is checked to indicate there will be a cover on the
The 3rd through 6th combo box will each be disabled by default and
will be enabled when the list box which indicates the additional
sect...Anybody have a suggestion on a good beginner on asp.net
I have been working with win forms C# for 1.5 years and xml.
I have not been using any kind of web development or html so I'm totaly new
I want a suggestion for a good book on asp.net for a newbie like me
I would strongly suggest the following:
ASP.NET 3.5 Unleashed
by Stephen Walther
When I first started learning ASP.NET, I had almost no experience in .NET,
web or desktop, other than an extremely basic college course on ASP.NET 1.1,
but they did very little in that. But I wanted to learn more about ASP.NET,
and my professor recommended ASP.NE...