User Defined Cells counting
Im tryin to find out how could I count a user defined cells (6 rows)
containing a string (ex. 2435 Smith Dr) using a formula. Currently, I'm
entering the count manually and I know there's a solution how to automate the
counting. If the cell is empty the value to be returned for that cell must
be 0 and if it contain the string, its value is = 1..This is how I'm
approacing it but it doesn't work using the IF function....Thanks
I'm not sure what you are trying to do, but you might look at the
Office Graphics - Visio
Microsoft Co...Timesheet week in Data Analysis
I am using Project Server 2007 and my work week is Monday thru Sunday.
However, when I go to Data Analysis, the timesheet view only shows Monday
thru Saturday. How can I reconfigure this to show Monday thru Sunday?
Check this link:
It might assist with setting up week days in data analysis section
> I am using Project Server 2007 and my work week is Monday thru Sunday.
> However, when...How can i dived a cell in excel
I have a very large spreadsheet to work on and i have to have 2 colums one
with a number and one with a name how can i move all the other names into a
colum without having to do each one individually????
maybe try 'Data - text to <columns'
"LauraCrosssan" <LauraCrosssan @discussions.microsoft.com> schrieb im
> I have a very large spreadsheet to work on and i have to have 2
> with a number and one with a name how can i move all the ...Formatt cell
In Excel 2007 I am trying to select an entire column to do the same thing
for each line.
Column c is hours worked, column d is pay per hour and I want to have column
e be the total $ for that day.
I don't want to add the formula =product(c3:d3) and so on each time to
How do I make column do this atomically each line?
Thanks in advance. Bob.
I'll answer this for 2003.
Enter your formula.
Select the cell. There should be a little box in the lower RH corner. Drag
it down to the remainder of the cells you want to populate.
"bob b...creating a file of particular extension
i am using ms access 2003, vb6.
i want to create a file of extension ".gms" . how can i do this?
how can we create a file of particular extension?
...Copying locked cells
I have a ss with formula in locked columns and the whole thing protected to
stop the formula being altered. When the user comes to the last row in
which there is a formula she needs to copy this last row and paste into
however many rows she needs to complete her figures. However the protection
is not allowing the paste function to work.
I know this is probably quite basic but your forum has taught me that I know
very little about Excel.
Maybe you could give the user a macro that would copy the row above (including
If you want to try, start at David McRitch...Where Do Messages Go??
If there isn't a kink in my program and it's behaving as it should, I hope
someone can answer my questions.
Messages disappear. Example: I e-mailed a friend, who e-mailed me back. When
I answered that response, I could find no trace of it in "sent mail" or
anywhere else, and the item in my inbox maintained its appearance as unread
mail. If I click "mark read" it disappears altogether. I've lost several
messages this way.
Also I seem to be unable to drag a message from one folder to another. It
gets lost in the transporter, never to be seen agai...Formulas in a cell
Hi, new the the forum.... :)
I needed some help regarding formulas and text in one cell. What i'm
trying to do is develop a simple formula to calculate a simple number.
The formula i have is: =(R3*12)-((R3*12)*0.1)
But the problem (or myabe not a problem :( ) is that i need it to show
as such: $103.57;1;NO;Case Price
Is it possible to have a formula and text in the same cell, if so, how?
Any help would be appreciated. Thanks.
sabrol's Profile: http://www.excelforum.com/mem...how do i allow fields to be either input or output in excel?
i am trying to build a series of financial calculators in excel. Each has
3-6 fields and 1 output field. What i want to do is allow users the
flexibility to leave whichever field blank that they wish and the model will
solve for that blank field. so the same model can be used a number of
different ways and to solve for any of the possible variables. i see this
feature in online calculators but i don't know how to set up my models this
way. Any help would be greatly appreciated.
...Where do the Archives Go?
I cannot find the information Outlook claims to have archived for me. Yes I
know how to display the archived calendar, but it's blank. Any ideas? Thanks!
I use XP, and Office 2007.
"6Sigma 5s No Clue" <6Sigma5sNoClue@discussions.microsoft.com> wrote in
>I cannot find the information Outlook claims to have archived for me. Yes I
> know how to display the archived calendar, but it's blank. Any ideas?
> I use XP, and Office 2007.
Why do you think Outook is arch...How to hide a cell if a formula returns no value?
HI again all,
what I'm after this time is a way to hide a cell by using a formula.
This is pretty much solely for formatting reasons so that the sheet can
be cut and paste into word from excel without empty cells coming up.
I need something like this;
cell a1 contains "whatever is entered into cell a1"
in cell a2 =IF(a1="",Hide cell a2,a1)
not an overly useful example I know, but hopefully you guys get the
jist of what I mean,
----------------------------------------------------------------------...storing historical data in Access
Hi. I am creating an Access database to store information about
employees, such as their job title and address info. However, I also
need to store their historical job title and address info as it
changes. I have other tables in the database to store info on their
different benefit plans. In the employee info table, I have their
Employee ID (the number that the company assigns to each employee) as
the primary field. So, it will not let me add duplicate entries for
each employee. I thought about making the primary key an autonumber
field but I need the primary key to be the employee ID so...Price/cost fields need to be able to go beyond 5 decimals.
When we receive product it comes in $ per metric ton, which we convert to $
We sometimes receive product in millions of lbs. in one line item, when we
convert from $/MT to lb./MT the limit of 5 decimal places in a currency field
causes pretty lare rounding errors to occur in our extended cost.
This causes our posted cost in GP to be different than what we actually pay
The ability to extend beyond 5 decimals in the currency field would solve
the problem, but for now it is not possible in GP.
This post is a suggestion for Microsoft, and Microsof...Multiple calendars, how to choose which one meetings go into
I have 3 calendars setup in outlook XP , when someone sends me a meeting
request how can i change which calendar the meeting goes into, at the moment
they all go into what i guess is the default calendar which i want to change
to a different one
You really can't change it. Outlook treats certain folders special.
"Chris S" <firstname.lastname@example.org> wrote in message
> I have 3 calendars setup in outlook XP , when someone sends me a meeting
> request how can i change which calend...Go to page
I have a long document and need to go the certain pages without having
to scroll down. How do I go to a particular page?
This is a multi-part message in MIME format.
Press Ctrl+G to open the GoTo dialog, and enter the page number.
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"richard" <rmk@wo...Open a workbook and get data from it
I'm working a project where I've got a list of names in one spreadsheet, and
I need to pull corrasponding data from another spreadsheet. The concept is
simple.... get a name from spreadsheet1, then go into spreadsheet2, find
that username, and copy the row over to spreadsheet1. At least that is how
you do it manually.
In excel VBa, from one workbook, how do I a open another workbook and
worksheet then get the correct data i need?
Modify to suit
Workbooks.Open Filename:="C:\sourcefoldername\sourcefilename.xls&q...Bring all data from a cell to a listbox inside a form
I have a cell with data separeted by a ";" caracter, for example:
So when I initialize my userform I would like that my listbox
"lstTest" load the data in the cell (1,1)
But I need the data in lines (the separation is the ";" caracter).
lstTest (looks like)
Thank in advance!!!!!!
If you're using xl2k or later:
Private Sub UserForm_Initialize()
Dim myArr As Variant
myArr = Split(Worksheets("sheet1").Range("a1").Value, "...Is it possible to synchronize data from an SQL table to an Exchange Server
Is it possible to have a replication or synchronization between contact info
stored in an SQL db's table and the Contacts or Public folders of an
Sure - programmatically, it can be done. Check out MSDN for more info.
Comsphere - "Where Knowledge Transfer is Key"
"D Gauthier" <email@example.com> wrote in message
> Is it possible to have...How Excel converts % sign in a cell and use in formula
I am trying to figure out a formula in Excel that I know is simple, but it's
I understand about the order of operations and what has to happen first and
the absolute cell reference. I'm confused about what the 1 is in the
(1+$F$9)...the info in cell F9 is sales tax and is written as 8.25%.
Thanks in advance for the help.
Peggy Duncan, Author
Conquer Email Overload with Outlook
> I am trying to figure out a formula in Excel that I know is simple, but it's
> been years....
> ...Here we go again
Well, once again CashEdge is not connecting/syncing with Money and MSN
Money. I guess I won't run right out to buy Money 2007. Even if the software
were an improvement over M06, it cannot be any better than the weakest link
in the sync chain.
A known problem, David -- and not unique to the version of Money. Look at
"David Haynes" <firstname.lastname@example.org> wrote in message
> Well, once again CashEdge is not connecting/syncing with Money and MSN ...Enter date in one cell, and the week ending date [Sunday] appears in the "W/E" cell
I have an XL 2003 workbook that I enter the date an event occured in
cell C7. I want to make another cell [C2]display the week ending date
[Sunday], based ono the date entered in cell C7. How can I accomplish
> I have an XL 2003 workbook that I enter the date an event occured in
> cell C7. I want to make another cell [C2]display the week ending date
> [Sunday], based ono the date entered in cell C7. How can I accomplish
On ...cell reference question
I'm as new to Excel as can be, so be gentle.
When making reference to a certain cell (say, Cell J60, containing a total),
what's the difference between using =J60 and $J$60. I've read about this in
the Microsoft KB but I don't have enough experience to understand it. Can
you put it in as simple terms as possible for me?
A million Thank You's!
"Island Girl" <IslandGirl@discussions.microsoft.com> wrote in message
> what's the difference between using =J60 and $J$60
$J$60 is what is...mail merge has the open data source not available
publisher 2000 under mail merge > open data source.
only create publisher address list or edit publisher address list.
all other commands are greyed out and unavailable.
I have a text box and select that before looking for the command.
Have you created a Publisher list? Where is your data source? What exactly are
you trying to do?
Mary Sauer MSFT MVP
"Sammc2" <Sammc2@discussions.microsoft.com> wrote in message
> publisher 200...Not all emails going out??
For the last week or so, send few, my emails have not been going out, or not
going out to all parties I access from my address book. Just tested by
sending one to myself...went fine. Sent second to a single party and cc
myself. Did not receive my cc in outlook, but it did show up in my iphone.
Tried a third to a group of people...through a single address book contact,
and nothing happened. I am strictkly novice, but have not had this problem
before. Any ideas???
Wilson Kobel;110315 Wrote:
> For the last week or so, send few, my emails have not been going...Forced new line in a cell: Excel
I wanted to start a forced new line after typing down the texts which
wraps down automatically in a given excel cell. Pressing [Enter] just
like any other Microsoft Office documents would take me to the next
cell as selected!
Googling some online help provided a [Alt]+[Enter] keystroke would
serve the purpose. But, that's not happening, is that a bug for excel?
But, it works in my coworker's pc!
So, it's not an Excel bug - more likely to be something to do with
your PC. Try swapping the keyboard with your co-worker to check that.