phone that works with live calendar?
I have been using google for my business for a few years and hate it as it
sometimes dups the event. I started to use windows live mail and love that
the calendar syncs up from the desktop to online. But one issue I have found
is I can not log on via the web when on the road to view the calendar. Is
there a phone that allows this? I don't care about syncing my phone with the
calendar if I can view it online that would be fine. I am also due for an
upgrade on my phone so if there is a certain phone that will work that would
be great. I am currently using a motorola cliq, that...Add text to formula?
I have this formula kindly given to me in one of these Excel ngs:
=COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You Lost*")
The challenge is that any custom text I add to the cell formatting
doesn't show up in the cell. Would it be possible to add something
like this text below to the above (but also including line breaks)?:
Formula result of: =COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You
*********************...Counting Dates of Occurrences
I am developing a spreadsheet to show the date and time an event has occurred
at a location. The cells indicating date and time are custom formated to
display mm/dd hh:mm. The first occcrrence is shown in column G, the second
occurence in column H, the third iin column I, and so on. This works fine,
but I need to count the number of occurrences shown in each column. Can you
assuming you are using excel dates and times
"wally" <email@example.com> wrote in message
news:6EEBFCEB-6FAC-40F2-B8B7-04...Creating macro for slightly complicated formula
I'm really new to the whole macro business so I really need help. I'm trying
to create a macro to solve this equation
D =(Sum from 1 to Nt ((X - Xmean)^2/Nt))^0.5 ......I hope it's clear. I
don't know hope to format here.
Anyway, I have a range of Xs that are Nt in number and Nt is unknown so it
will have to be found first and this has to be in the code. I'm trying to
avoid having another column containing the values of (X - Xt)^2/Nt. I just
want D to be displayed in a designated cell, like F2. This code will be used
for multiple workbooks, all the data al...Adding formatting to inline formula..
Is there a way to merge text and a cell value such that the cell value
has a particulat format.
For example, suppose I want to display the following in a cell:
Less 5% of (contents of another cell) =
I could put something like the following in the cell:
="Less 5% of " &A1 "="
However, is there a way to format the inserted value from A1 as bold or
italics or a particular number format?
Bold,italic etc will not work in a formula but will in just text. In the
formula bar, just highlite the desired and format as desired.
But you can use TEXT (look in help...How suppress chart points
I want to suppress chart points for a cumulative line graph of monthly
telephone costs where the particular month's values have not yet been entered
but there is a formula in the cell which currently returns null but will
return the value once it is posted on the accountmaster sheet.
Use NA(). The will cause the data marker to be omitted. Note the line will
be interpolated between valid data points.
Something like this,
=IF( <test> , <value> , NA() )
Andy Pope, Microsoft MVP - Excel
"sarcastix" <sarcastix@di...Show/Hide Functions/Formulas
For some reason the keyboard shortcut (Ctrl+`) does not toggle show/hide
Selecting Tools>Formula Auditing>Formula Auditing mode works fine.
I am wondering if it is because I have regional (keyboard) settings set
to UK English Extended.
I know the `(grave) key works and have tried it with both Ctrl keys with
"Smirnoff" <firstname.lastname@example.org> wrote in message
> For some reason the keyboard shortcut (Ctrl+`) does not toggle
> show/hide function.
> Selecti...How to increase the number of columns.
I need more columns in excel (I now it sounds crazy). If there is no
solution, than how to transform columns in rows?
Please � I�m desperate�����.
istancutu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35749
View this thread: http://www.excelforum.com/showthread.php?threadid=555288
Nel post news:email@example.com
*istancutu* ha scritto:
> I need more columns in excel (I now it sounds crazy). If there is no
> solution, th...count ?'s
So i was wondering if there was a way to use the count w/ specifi
like in 1 cell can i have it count all the a's, all the b's-g's.
know i can you count(a) and it will count text but can i specif
specific text for it to count
Message posted from http://www.ExcelForum.com
You can use the "*" wildcard.
If you would like to use a specific cell to designate a character, so that
it could be easily changed:
Please ...Formula to get date from text string
This is what the cell currently looks like:
I would like the formula to return only: 10/01/09
Does anyone know what formula I should use? Any help would be greatly
Here's one way:
though this will only work if the date is in the normal format for
your region (does it mean 10th January 2009, or 1st October 2009 ?).
A safer way might be:
depending on the answer to my earlier question.
...Is there a formula result that will not appear on a chart
I would like a chart that updates for daily sales statistics over the course
of the month without dragging a formula, such that I enter the day's sales,
and the chart updates for the new day (to be viewed against a target line).
I do not want the chart to show the "zero" value for days which have not yet
occured. I tried using a formula, but all formula results register on the
chart (i.e. if the formula result is blank, or space, or a word, the chart
plots a point at zero). I need it for a cummulative sales number day by day.
Jon Peltier has information on c...sum function not actually summing??????
OK, I'm trying to sum numbers a column. This is exact representation, cells
F19 to F22:
I sum into F23 and get the result of only F19 *$11,087.* F23 cell formula
This is a sheet I downloaded. I added a row (F21) to insert the $2400.
When first sum action didn't work, I thought maybe it was based on cell
format, so I reformatted to label them currency (this shows in cell
properties), so it's not an issue of cell format standardization.
Also, I copied the numbers from F column to a new one and pasted as ...sum command do not display the result eg:=sum(c5:c8)-total not
sum command do not display the result eg:=sum(c5:c8)-total not display the
result in the cell
even when sigma is clicked the same
What is displayed instead?
If you see the formula, then format the cell as General (or anything but text)
and reenter that formula.
If you see the wrong answer, then maybe you have calculation set to manual.
is how you'd change it in xl2003 menus.
If that's not it, then maybe your values in those cells (C5:C8) aren't really
numbers. Reformat that range as General (not text) and reenter the values.
abbbalu wr...Specifiying Successive Page Numbers for Workbooks with Multiple Tabs/Pages
Does anyone know how to make a workbook with several tabs
print with successive page numbers from the first page of
the first tab to the last page of the last tab?
Select all of the tabs and then print the lot in one go!!
"M.P." <firstname.lastname@example.org> wrote in message
> Does anyone know how to make a workbook with several tabs
> print with successive page numbers from the first page of
> the first tab to the last page of the last tab?
I have tried that before, but each...Extract numbers from cell with Text and Numbers
I hope someone can help.
I have a column of cells. Each cell contains some text, and then a
number in parenthases, then a comma, and then come text, and then a
number in parenthases, This repeats probably as many as 5 times,
though some cells have fewer then 5. I want to somehow, if possible,
extract JUST THE NUMBERS. If I can automatically get a total so that I
can average the total (dividing by a number in another column, but in
the same row as the numbers extracted) that would be great. I am most
concerned with not having to manually enter the numbers again.
If anyone ha...Sum #2
thanks Frank, I like your sumif solution
sgrech's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14501
View this thread: http://www.excelforum.com/showthread.php?threadid=271816
...Limit number of CPUs?
Is there a way to set the number of CPUs SQL Server will use (SQL 2005
Enterprise)? I know you can do it per query, but is there a way to set it
across the board (e.g., in the registry or in the configuration manager)?
Can you explain more of what your intent is? There is a setting called
MAXDOP (Maximum degree of Parallelism) at the instance level. But you need
to understand what it does and if that is really what you want.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Neil W" <email@example.com> wrote in message
news:uAWNEedbKHA.16...Formulas over multiple worksheets
Is it possible to apply a formula to multiple worksheets? The scenario
a user has 52 worksheets, one for each week of the year. In A1 of th
first worksheet, she's entered a date. She'd like to use a formula t
title A1 in each of the 52 worksheets like A1+7, A1+14...etc. so sh
doesn't have to enter 52 titles
Message posted from http://www.ExcelForum.com
Well,my stupid way goes like this:
On Sheet2, A1, enter:
The initial time can be done manually or via vba codes(sorry I don'
know how), but afterwards, she can change al...Sum formula that stays constant
What I would like is to have a format that a date will be
entered into A1. Cell A2:A... will have what will be the
number of items that came in at a certain point of the
day. In cell C2 I would like it to use a count formula if
the date is whatever is in A1 and when the date in A1
changes, I would like the summed data to remain in C2 if
that makes any sense. Thanks for the help.
"Todd" <firstname.lastname@example.org> wrote in message
> What I would like is to have a format that a date will be
> entered i...How to write this 4 condition nested formula?
I'm trying to figure out how to write a formula to satisfy the followin
If cell v4>1 and cell x4="FR",-1 and
If cell v4=1 and cell x4="FR",3 and
If cell v4>1 and cell x4="CL",2 and
If cell v4=1 and cell x4="CL",-3
So I have 2 cells I'm working with here and 4 conditions that I want t
assign: either a -1,3,2, or -3, depending on whether the user types th
text FR or CL into cell X4.
Thanks and happy holidays.
bortz's Profile: htt...Excel : Counting on two columns
THIS IS AN MICROSOFT EXCEL QUESTION: URGENT
Suppose I have two columns "A" and "B".
Not Error Open
----- -> Represents blank rows..
How will I find Error which are open in columns 0-7
(including blank rows)
Try putting this into C1
Hope it helps,
Message posted from http://www.ExcelForum.com
...count days in a date range
I am trying to count the number of days within a given
date range but leave out saturday's and Sunday's. Is
there a way to do this? Using the function Days360 seems
to be the right path, and counts all the days between the
range, but I am not sure how to customize from there, if
it is even possible.
if your dates are in a and B1 use
Note: the Analysis Toolpak Add-in has to be installed for this
> I am trying to count the number of days within a given
> date range but leav...Removing formulas
I have 2 worksheets, on worksheet 2 I created figures by using formulas
using refrences to the other worksheet (worksheet1). I now need to use the
new figures on worksheet 2 to create a new worksheet using different
formulas to create yet a different set of figures.
Every time I try to use the new formula on worksheet 2 it just puts a 0 in
the cell and says something about Circular formula. I have tried to copy
and paste the worksheet into a new excel window but it just copies the
formula with it.
I want to be able to get rid of all the formula on wsheet2 but still leave
the figures...Formula for getting values in File-Properties-Custom
Is there a formula for retrieving values stored in the variables in
...Why am I getting #VALUE! when working with a TIMEVALUE formula?
This formula is working on other pages within the same workbook, yet it does
not work on a newly inserted worksheet. NOTE: this orginial workbook was
created in an early version of Excel (95 or 98), now using 2000.
what is your exact formula and what is in the referenced cells?
TIMEVALUE ERROR wrote:
> This formula is working on other pages within the same workbook, yet
> it does not work on a newly inserted worksheet. NOTE: this orginial
> workbook was created in an early version of Excel (95 or 98), now
> using 2000.