summing a column according to criteria of two other columns
I am creating a cash flow forecast sheet and trying to add up the
project values of a particular service provided in june this year. i am
attempting to do this by referring to a sheet called data which has a
column of project values (N), a column with the month and year of the
project (V) written as 62004 and a column of services (E) of which i
want to select those projects where the service was Translation -
Standard. By looking at the help for countif by multiple criteria i
altered the formula to a sumif. I am using the formula...
Standard'...Hiding "0" values in pivot table
In a worksheet I have a listing of stock records with ItemNumber, Date,
StockLocation and NumberOnStock. When I make simple Pivot Table with
ItemNumber and StockLocation as rows and select a Sum of "NumberOnStock"
I would like to hide rows where the sum is "0". But this does not seem
to be possible.
Tried to follow the guidelines in the Microsoft article:
But no luck :-(
You could use conditional formatting on these cells - highlight the
cells,...Not allowing Alpha Characters in a Numeric Formatted Column
I have a spreadsheet that we provide to vendors where they have to fill
in their product data and send it back to us where we import this data
into the products database.
I have the spreadsheet set up the way I want it and have drop down
boxes where applicable for data validation.
I have several fields that i only want #'s. Sometimes integers,
sometimes there may be a decimal. I set the formats accordingly.
HOwever, you can still type the letter A or B or C etc... in there. I
only want them to be able to type in #'s.
In access I can use a mask. Is there anything similar in Exce...Cannot Create File When That File Already Exists Installation Error
I'm running a test install of MSCRM on a VPC and I'm getting an error
message that says
failed. Cannot create a file when that file already exists.
It gives me the option to Retry, which immediately fails and displays
the error again, and to Cancel, which will end the installation
process early and show me a log, but the log doesn't say what file it
is attempted to create that already exists.
The VPC is the latest one (not the one that's coming out right NOW,
but the last one). The server is running on S...To get the same header,footer and sheet titles across multiple sheets of a workbook.
I want a workbook to have the same header (as some cell value of a
sheet in workbook) and similarly same titles (rows and columns titles)
in different sheets. I reached to the following code. It worked well
for the header (and also footer) but it didn't work for the rows to
repeat at top or columns to repeat. It only works for the active
sheet. How can i make my work done?? The main problem i think is to
make ActiveSheet.PageSetup.PrintTitleRows work across multiple sheets.
Please help me. I have the code attached here for yur reference.
'this is the workbook c...Hiding formuals in cells question
Hi. I was wondering if there was a way to hide the formulas in cells without
protecting the sheet. I am making something for other teachers at my school
and I want to hide the formulas so they won't mess anything up on the
spreadsheet. Any help would be greatly appreciated. Thanks!
not without protecting the sheet but why is this a problem for you?
"JP" <JP@discussions.microsoft.com> schrieb im Newsbeitrag
> Hi. I was wondering if there was a way to hide the fo...display columns alphabetically
Columns used to display alphabetically left to right. It changed to now
displaying numerically left to right. How do I change back to alphabetically?
Go to Tools|Options and then in the General tab, uncheck R1C1 reference
Where there is a will there are many ways.
'The Code Cage' (http://www.thecodecage.com)
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=136818
Perfect, thanks for easing my f...Errors
I get the following problems in Outlook 2007 Professional new installation
with Windows 7 ultimate O/S -
1) When I try to import a Personal folder from another .pst file of same
Outlook 2007 version it gives me an error "The Messaging interface has
returned an unknown error. If the problem persists restart Outlook". This
error never goes off even after restart.
2) Trying to add new Outlook data file through Data File Management after
selecting type of storage for new outlook data file as Office Outlook
Personal Folders file and selecting the specific .pst file it g...excel error
run excel, error :
"This program has performed an ilegal operation, and will
If the problem persists, contact the program vendor"
what happen ? please help me?
...hide my name
When replying to an email or creating one from scratch how do i hide my name
in the "from" field...thx
fred <email@example.com> wrote:
> When replying to an email or creating one from scratch how do i hide
> my name in the "from" field...thx
Are you saying you want the reply to be anonymous?
Brian Tillman [MVP-Outlook]
no, I don't mind if my email is revealed.. just my name. I have tried by
removing it from the "User Name:" field in the email account but it
continues to show up. I have also removed from the header informati...elunknown error
on first look the windows live mail seems like a very nice email application,
however the "unknown error " that prevents me from deleting junk and having
it disappearor becomming stuck as a permenant outbox item is becomming enough
of an agravation that i will soon return to outlook or even thunderbird. I
have followed instructions to work offline and configure advanced settings in
tools to work around this, but i do not wish to do this daily.
Is there a permenant fix for this?
"Elijah" <Elijah@discussions.microsoft.com> wrote in message ...Convert Column Letters to Number
I'm looking for a function to convert a "large" column letters (up t
10 characters) to it's equivalent in number.
Message posted from http://www.ExcelForum.com
Here's a VBA function that gives the results you want:
Function ColumnToNumber(sText As String) As Variant
Dim Bytes() As Byte
Dim Letter As Long
Dim Multiplier As Double
Dim N As Double
Dim Total As Double
ColumnToNumber = CVErr(xlErrValue)
If L...Excel startup bug: VBA Run-time error 76??
Yesterday, Excel started giving me error messages whenever I
start it up. I uninstalled Office 2000, reinstalled it, and I
still get the same error.
Here is what happens. MS Visual Basic displays a dialog box that
Run-time error '76':
Path not found
When I hit the debug button, it highlights (in yellow) the
following line of code:
lengthOfFile = Filelen(registryValue)
What should I do to fix this annoying problem?
Delete the ZZZ.
It keeps spam
off the server.
Start it with a switch
"C:\program files\microsoft office\office\excel.exe" /...Hiding and Un-Hiding Data fields
I am using a form for people to select data via dropdown menus and then
having it run through a query to filter results. Is there a way that I can
have certain feilds hidden until a toggle button or something of the like is
Basically I want have three choices of buttons: Year, Quarter, and Month.
What I ideally want to happen is when someone selects the button for year, a
hidden drop down menu appears where they can then choose from the available
years to filter through the query.
I would say I am above average with using access, but I have no idea how to
hide fields and then...Command messages for FrameWindow member objects
i am working on an SDI application and in that application i need to
broadcast a message to all the objects. So i used:
SendMessage(WM_COMMAND, ID_SOMEID); // From within the document Object
Then i added ON_COMMAND_EX macros in various objects for handling and
further passing the message. I realized that MainFrame object was
getting the message but a dialog bar object which is a member of
MainFrame was not getting this message. I tried a lot but couldnt
figure out why dialog bar object is not getting my command message when
it is getting other command messages and update UI comma...How do I hide gaps in an Excel 2007 chart?
I have a bar chart that is showing gaps and i don't want them. The select
data > hidden and empty cell button does not give an option to hide gaps. I
think by default they are hidden but if you even click on this to see what it
does the gaps are shown and no way to turn off.
If you hide the actual rows then with the Plot visible cells only
setting on the gaps will be removed.
In xl2007 the setting is on the Select Data dialog, Hidden/empty cells
> I have a bar chart that is showing gaps and i don't want them. The s...Cannot add columns to custom views
I have a problem that is causing a major handicap.
I cannot add any columns to any custom leads view that I create. No matter
what, the only column that is displayed is the default key column (name) that
is there when the view is created. When I click on add columns, the dialog
box that is supposed to list columns that I can add to the view has no
columns listed at all.
I am logged in as the System Administrator when trying to accomplish this.
Also, when I create a filter criteria it is never saved. I save it, but
when I go back into it, it is gone.
Any help would be GREATLY apprec...Hiding a worksheet #3
I want to hide a worksheet. So, I went to the format menu and the "worksheet" option is grayed out. Why? And, how do I "ungray" it.
is your worksheet protected ?
> I want to hide a worksheet. So, I went to the format menu and the
> "worksheet" option is grayed out. Why? And, how do I "ungray" it.
I think Frank meant to ask about the Workbook--not the worksheet.
(Check under Tools|protection|Protect workbook or Unprotect workbook)
My question is: Is there another sheet in the w...PO Printing ERROR
I am facing problum in printing the Purchase order after approval.
When i open any PO and try to print it by pressing PRINT button it shows an
"Run Time Error 13, Type Mismatch"
and Quit form RMS Manager
Plz any one help me out from this problum.
...Hide images when Hiding Rows
I have inserted images into cells, but when I hide the column the images
are not hidden with that column, they just get squished between the two
cells next to the hidden cell. Is there a setting or way to tie the
image to that cell so that it hides/unhides appropriately with the row?
kurt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35686
View this thread: http://www.excelforum.com/showthread.php?threadid=554712
You cannot insert an image into a cell.
You can overlay ...Error while including <occi.h>
Actually i am developing an application in c++ to insert data into
oracle database and i am facing a problem while running the program
after including Oracle c++ call interface header file occi.h.Can
anyone help me about the solution of that problem.The error which
occered is given below.
e:\oracle\ora92\oci\include\occicontrol.h(1132) : error C2995:
'getVector' : template function has already been defined
e:\oracle\ora92\oci\include\occicommon.h(425) : see declaration of
e:\oracle\ora92\oc...syncronization error from outlook 2002 & active sync
when attempting to sync my pocket pc w/ outlook 2002
(windows xp-prof), i get two messages from outlook:
1. (microsoft outlook): no profiles have been created. to
create a new profile, use the mail icon in the control
then i press ok, and i get the following:
2.(microsoft outlook syncronization): sync. cannot be
completed because your personal information manager is
not running. ensure your pim program is running, and try
to syncronyze again. if your pim program is running,
restart your desktop computer.
i had created those profiles, but the problem persist.
t...VBA write macro change column with 3 number digits to 4 digits the
Do you mean
Range("D1:D10").NumberFormat = "0000"
"James C" wrote:
Use the white space (here) to record details of your requirements -
don't try to put it all in the message header.
On Jan 25, 1:51=A0pm, James C <Jam...@discussions.microsoft.com> wrote:
Thanks for your response
"Jacob Skaria" wrote:
> Do you mean
> Sub Macro()
> Range("D1:D10").NumberFormat = "00...Consecutive ma-open calls are failing with error 3051
Hello. I'm having a problem with exchange 5.5sp3
on windows NT 4.0sp6 TSE (I know, pretty old
environment. The upgrade is in my todo list).
I will try to explain the issue. Sometimes I get
this message because space left on disk is less
"The MTA is terminating because the disk where
MTADATA is located has less than 10MB of space,
or an error occurred while trying to check for
free space on the disk. If disk space is low,
free up some disk space and restart the MTA. NT
Error code returned: 0 (non-zero indicates an
error while checking for free space) [BASE IL
TIMER 3] (16)&...Need to display an error message when a duplicate object is clicked.
Hi all, I'm new to Access and I'm creating a simple IT Inventory
database. My first form just has details on the device, and I want to
be able to have the users select an IP address from a dropdown list.
I have the list and the dropdown working flawlessly, but in my table I
selected No Duplicates, so that no one IP address can be used twice.
What I'd like to do, is that if the DB detects a duplicate, to pop up
a dialog box stating that the IP address is already in use and to
please select a valid IP address. By default, there is an error that
pops up when you try to save the rec...