Need text/detail of appointments in Word doc for non-Outlook users
Further to and concurrent with my enquiries about missing information in
appointments, I also need to share the entire holiday schedule with my Mum,
sister and cousin. They do not have Outlook. They do have Word. My idea
was to email them a Word document containing the holiday schedule.
I searched your help database and could only find references to techniques
which embedded an icon which then opened the Outlook calendar.
I need to dump the entire subject, text/notes and dates contained in
approximately 20 appointments so that they can be informed of our schedule.
How do...re: sum cells containing text
Hi. Can anyone help me please.
I want to sum the values of certain cells, that contain numbers and text
eg. cell B2 contains 32A
cell B3 contains 12B
cell B4 contains 6C
the text will always be a, b or c, and always stay on the right
Thanks in advance
With sample data like this:
cell B2 contains 32A
cell B3 contains 12B
cell B4 contains 6C
Try this formula:
With the above data, the formula returns: 50
Is that something you can work with?
-----------------...need a formula 11-15-09
need to find the formula for b3 is 8 hrs c3 = -.50min / b3 is less than 8hrs
c3 -.25 example b3 8. hrs c3 7.5 hrs / b3 6. hrs c3 5.75
Terry: take a big breath and retype this slowly using punctuation and line
feeds. We do want to help but this makes no sense to me Unlike cell phone
text messages, there is no word-count cost.
Microsoft Excel MVP
"Terry" <Terry@discussions.microsoft.com> wrote in message
> need to find the formula f...Exclude Header from Range?
Hi, can I exclude a header from a range in an equation, i.e.: "C:D" to
exclude 5 rows from the top? Thanks
Depends what you are trying to do.
You could have =SUM(C:D)-SUM(C1:D5) for example.
"nastech" <firstname.lastname@example.org> wrote in message
> Hi, can I exclude a header from a range in an equation, i.e.: "C:D" to
> exclude 5 rows from the top? Thanks
or equilavant equation
> Hi, can I exclude ...How to draw a regression line on 7000+ dated data with Excel 2007
How to draw a regression line on 7000+ dated data using Excel 2007
Are your "dates" actual Excel dates or just text?
With actual Excel dates, pre-2007 versions have no problem doing simple
linear regression. To interpret the results though, you need to remember how
Excel dates are stored: An Excel date is the number of days since 1900, so
the numeric value of today's date is 39736, and the intercept of the
regression will be the value of the relationship extrapolated to 30Dec1899
(since Excel mistakenly considers 1900 to be a leap year)
"Gordon Lee" wrote:
>...Get rid of "folder sizes" and "data file management" links
at the bottom of the folder list? I'd love to remove these to make more
space available in the list. Thanks.
...working with default data files
I am using IMAP and I would like to config outlook to bring all my emai
to the default "personal folders" or delete that folder. Is tha
g.garrette's Profile: http://www.officehelp.in/member.php?userid=491
View this thread: http://www.officehelp.in/showthread.php?t=124989
Posted from - http://www.officehelp.i
g.garrette <g.garrette.2gnhe4@NoSpamPleaze.com> wrote:
> I am using IMAP and I would like to config outlook to bring all my
> email to the default "personal fo...Multiple Conditions Formula Help Needed
I currently have a formula that I have used to calculate commisio
rates. We had a 2 rate plan. If sales were below a certail threshol
then apply this rate and if above apply this rate. I used an IF/THE
formula. We have recently switched to a 4 rate plan, and I am unsur
how to create a formula to reflect this.
Message posted from http://www.ExcelForum.com
One approach would be a table to use with VLOOKUP. In the formula, where you
now have a rate, use VLOOKUP.
On Wed, 21 Jul 2004 16:53:11 -0500, chiwavdg
I am using Money 2002 (simply because later version don't offer anything new
that I need) but I cannot find anyway or option that will allow me to store
the data externally. I can store the backup in a variety of places, however,
I would like to keep the primary files, and the automatic backup, off the
hard drive and unaccessessible to hackers. Does anyone know how this can be
You can copy your .mny file to any media you like using the normal Windows
tools from My Computer or Windows Explorer. You can also usually backup to
these media using browse from within the M..."create mscrm.sql" error on 3rd (re-)install
I have installed CRM 1.2 on SBS2K3 twice as "advetureworks cycle" and "msdn
subscriber" with only 90% success because of conflicts on the web site. I
have removed the conflicts but now CRM installer errors trying to create the
new database as (default) local service.
My login has SQLServer db_creator permissions and I can create a DB, so I'm
totally confused. Can I workaround this somehow ? What login needs to be
given db_creator rights so Install can run te SQL scripts ?
have you deleate the complete the old date from AWC? Have you delete the
...sorting data #2
Sorry if this has been asked before, but ive searched to no avail, as I
dont really know what to call the question.
i have the following
Can I automate the sorting of this data so that for each value in
column A the Values in Column B are totaled, ie it becomes
Message posted from http://www.ExcelForum.com/
You could either sort your data by column A and then Data|subtotals or you could
add headers and do Data|pivottable.
> Sorry if this has been asked before, but ive searched to no avail, as I
>...Re: Saving CSV in Unicode?
I'm using Excel to write a CSV in UNICODE. If I simple save this file then
all the unicode text is converted to ASCII '???' things. So I specify the
file name like "test.csv" and specify "UNICODE Text" in FileType.
Now when I open the file in Notepad, I find no comma but TABS as separator.
If I open the file in Excel, it prompts me to select delimiter with which
the file was saved. If I select anything except "Tab" then all the data is
shown in single column that I've to break using "Text to Column" Feature.
And you know my clie...data entry problem
I am trying to make a detailed sheet of some inventory data whic
changes each month. The first sheet just has general data, but ther
are more columns on the second sheet with varying expanded details
Column A - product number
Column B - color
Column C - available
Column D - Misc notes (may or may not be filled in)
A B C D
2310 blue yes
2348 red M/R must sell soon
2362 blue no
(some text data in-between)
2405 red M/R need to be redone
2450 grn yes sell cheap
2477 wh yes
Month 2 (new ones may be added, and sold item t...Need help plz! Unable to Send/Recv emails in OE.
I'm sorry if this is a dumb question but I just set up my Outlook Express
and I'm unable to Send/Recv emails which is strange because I already have
an msn.com email account which works perfectly but I wish to make OE my
default email and that doesn't work. Whenever I try to send an email or
press the Send/Recv button I keep getting these two error messages:
1: "The service is currently unavailable. Try again later. Account: 'MSN
Mail Server', Server: 'http://services.msn.com/svcs/hotmail/httpmail.asp',
Protocol: HTTPMail, Server Response: 'Service Unavail...Re: How can I search for a ? in Publisher?
I just sent my suggestion to the shredder. <G>
Don - Vancouver, USA
"May your shadow be found in happy places." - Native North American
"Don Schmidt" <Don Engineer@PNB.Retired_1987> wrote in message news:...
>I see you problem; don't know if your search can be done in Publisher but
>here's a way of finding the "?s" in your file.
> Save the file as a PDF and do the search in your PDF viewer program. This
> works for me using PDF-XChange to create the file and PDF-XChange Viewer
> to do the searching....Data counting
I need a solution for excel.
Sheet1. This worksheet excists of a column DATE where a user can fill in
dates. These dates are of the format: dd/mm/yyyy .
And a column AMOUNT. Where a user can fill in an amount.
This amount is of the format: number, decimal 2
05/07/2005 | 15,30
12/07/2005 | 34,80
12/07/2005 | 8,50
12/07/2005 | 12,90
20/07/2005 | 5,00
20/07/2005 | 7,50
24/07/2005 | 100,60
What I want to accomplish is the following.
Excel has to make a SOM from the amounts per date. and list these SOMs on
in the format:
05/07/2005 | 15,30
12/07/2005 | 56,20
...Excel 2002 annoyance
I am using Excel XP amd Access XP
I regularly run queries in Access and cut and paste the results into a
new Excel spreadsheet.
The Access data is usually formatted numeric, fixed, zero decimal
Once pasted into Excel, it gains 2 decimal places and I get the little
green triangle in each cell inviting me to convert to numeric of error
Can anyone think of a way to retain the numeric formatting from the MS
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet mess...How do I not plot items with zero in a data series?
...how to include in codebehind page?
In classic ASP I have a include file that reads all cookies and put in variables to be use, in dot net I also have a ASPX file that reads all the cookies, but I am having problem using the file in the codebehind .vb page.
and then I thought I will just create a DLL and put in the bin folder, but I am having problem calling the System.Web.HttpCookie with in the Public Class.
Can any point me to the right direction how I can do this?
Thanks for help
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-=...How do I display data from multiple worksheets in a summary sheet.
I have over 100 worksheets which are layout exactly the same. I want to
create a summary sheet to display only certain information from all of
them...like name, sales total, numbers of calls. I don't want to consolidate
or tally the information just display them. Does anyone know how to do this?
Many ways to skin this cat
If the sheets will be always be accessible in an open workbook you could use
In a macro you could use
For i = 1 To 100
Cells(i, 1).FormulaR1C1 = &qu...Sort numeric data in more than 3 columns in excel
I have to sort 12 columns of numeric data in descending order on a
excel worksheet. I currently sort 3 at a time and then move forward.
For example, I have sales data for months Jan to Dec. I want each of
these columns to show zeros at the bottom when the macro is run. The
rows would increase in future but the columns would be fixed. The
worksheet would also remains unchanged each month. None of these
columns are of least significance.
Is there a way I could change a recorded macro to achieve this?? I know
very little of VB. This would be of great help!
All of the columns ...Need help #2
I have a column full of photo names such as 2801.JPG. There are aroun
500+ image names in this column. What I need to do is add "photos/" i
front of every image name in this column; e.g. "photos/2801.JPG". I
there any way to do this other than one at a time. It would take a ver
long time doing it this way. Thanks for your help
trimax's Profile: http:...Excel Data Integration
I'm trying to manipulate the adjust cost and general journal entry in Great
Plains 9.0. I'm succesfully set data in the fields of headers but having
difficulty on Scrolling window and also in activating radio buttons. Can
anybody have a sample code for adding/deleting/getting data from/to scrolling
window and email to me at email@example.com ? And I know there is a certain
number key for adding a line /data in scrolling window which starts at 16384
of SQCNLINE and increment itself for every line added. It will be nice if I
can also acquire how to use this.
By the way, I am usi...Re: IPM.Post instead of IPM.Note (Exchange Server 2003)
(Apologies for the repost - I types in "ms.p.e.application.conversion twice,
and forgot this group)
"Steven Wilmot" <firstname.lastname@example.org> wrote in message news:...
> could you tell me is there a similar patch for Exchange
> Server 2003 as there is one for Exchange Server 2000
> (http://support.microsoft.com/?id=817809) addressing the
> issue of "SMTP messages coming to public folders have a
> default type of IPM.Post instead of IPM.Note"?
> Thanks a lot,
...Re: this accidental unwanted mail 04-06-09
"agonis shala" <email@example.com> schrieb im Newsbeitrag news:...
> "::1" <cookie:firstname.lastname@example.org> schrieb im Newsbeitrag
>> "Joe Mc" <email@example.com> wrote in message
>>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message
>>>> Sorry, but this isn't e-mail.