combining data in multiple cells
is it possible to combine data from more than 2 cells without losing the data
from the cells? i know i can concatenate 2 cells, but what about data from 3
or more cells?
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
> is it possible to combine data from more than 2 cells without losing the data
> from the cells? i know i can concatenate 2 cells, but what about data from 3 ...multiple calls to invalidateRect not combined into a single update rect
I have an audio processing "plugin" dll that works with several
different host applications. I'm seeing a problem when the plugin dll
is used with one particular host application.
Our plugin app creates its own window and needs to redraw certain
rects within this window at a regular interval. We create a timer to
trigger this animation cycle. When the timer callback is called we
use invalidateRect to invalidate the individual rects that need to be
drawn. Usually, by the time that we see a WM_PAINT message, these
small rects have been combined by Windows into a sma...back up messages #2
I need to do a re-install of Windows XP. I am using Outlook 2003 and would
like to burn my important e-mail to a cd. Can anyone tell me how to do this?
"John & Jeannine Thomas" <email@example.com> wrote in message
> I need to do a re-install of Windows XP. I am using Outlook 2003 and would
> like to burn my important e-mail to a cd. Can anyone tell me how to do
> Thank You
just copy your pst file.
...Copying Data from MS Word into Excel #2
Unfortunatley the Word documents aren't tabled.
OptionTrader's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1495
View this thread: http://www.excelforum.com/showthread.php?threadid=26583
Could you convert it to Tables in Word (Table>Convert>Text To Table)?
"OptionTrader" <OptionTrader.firstname.lastname@example.org> wrote in message
> Thanks Sue.
> Unfort...Building reports in Excel, for data being entered in Multiple Workbooks by Multiple users
Hello - I have a group of nurses that keep a lot of patient data in
standard excel workbooks. I need to pull reports based on that data
on a weekly, monthly, and sometimes daily basis.
For now, I have been having them send me the data, and then I copy it
all into a single workbook, and then I build the reports. But I would
like to avoid this step, if possible, and somehow automate the
selection of the data in each of their workbooks.
Does anyone have any experience doing something like this.
Is it even possible to perform advanced filters and pivots (i.e.,
reports) of multiple workbooks f...Combining Statistics
I'm new to excel and need help in combining statistics from multiple
workbooks. I currently have 5 seperate workbooks (5 years) with different
data in each one. All the data applys to individual people. Let say person
"A" has data in one year and has diffferent data in a different workbook and
on a different sheet in another year. I just need to add this data togetherin
a new workbook. I know I can open both workbooks and have the add statement
do this, but year after year it getting to be a very big statement. Is there
a macro that can scan the workbook for a patricular p...Business Portal/FRx Report Issues
After generating a 15 page report in FRXReport Designer I am able to
view the entire report in IE. After the report has been published to
Business Portal on the page tabs show at the bottom and the report
gives the error:
The page cannot be found
The page you are looking for might have been removed, had its name
changed, or is temporarily unavailable.
...Is it possible? #2
Is it possible to have Outlook open up a specific Inbox?
Yes. But need more detail as to which (inbox). Some call an Inbox any =
folder within Outlook and some have more than 1 identity. Please make =
yourself clear when posting so as you can get an answer correctly
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"LJSNYC" <LJSNYC@discussions.microsoft.com> wrote in message =
> Is it possible to have Outlook open up a specif...Unknown Recipients
We have two e-mail domains on our Exchange 2003 SP2 server.
For one e-mail domain, @abc, when an incoming e-mail has an unknown
recipient, it is discarded and an NDR returned.
For the other e-mail domain, @xyz, when an incoming e-mail has an unknown
recipient, it is bounced back to our gateway server, which recognises the
valid domain name and returns it to Exchange which bounces it back again.
This continues until the Hop Count is reached.
How do I configure the Exchange for the xyz domain to discard the message
1st time and send an NDR ?
Sounds as if you have not configured the ...Creating an opportunity report that lists monthly revenues
Our senior execs would like an opportunity report -
similar to the pipeline report - that lists our revenues
In the application as it exists today, I can put input
the total amount of the opportunity, or I can list a
bunch of products that add up to a total opportunity
amount... What I'm looking for is a way to input an
upfront setup cost and then monthly service costs for
each customer. For example, $10,000 setup cost and then
$2000/month for the next 6 months, and then $5000/month
for the 6 months after that, and so on. These amounts
would all be part of one opportu...Lotus 1-2-3 file #2
How do I convert a lotus 1-2-3 file (bill.123) to Excel
I think Lotus has the option to save its file as Excel file. So this
should be the easiest way. AFAIK Excel has not build-in converter for
> How do I convert a lotus 1-2-3 file (bill.123) to Excel
I don't have the Lotus 123 program. I have the Excel 2002 program. A friend gave me a Lotus 123 file I need to convert and print out. It is bill.12
If you don't have 1-2-3 you can get Conversions Plu...Using Word to Print a Journal Report
I use Pocketjournal with Outlook 2002. I use Paocketjoural to track m
work as I go through the day, jobs related to computer tech support.
What I would like to do, infact 3 of us would, is to be able to tak
the info from journal and bring it into a readable/printable report i
Word. This can then be email to our boss.
Any ideas of a quick and easy way to do this?
Thanks for you help, this forum has been very useful in the past.
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelF...Two Spread Sheets one Function Needed
I have two spreadsheets
Spreadsheet A List in column A - Grant Number
Spreadsheet B List in column A - Grant Number
column B - EIN Number
These two different spreadsheets are a result of
downloads from two different systems. I've been
ask to specifically use a VLookUp nested function to
take the unique identifier in sheet a & b which is
is the Grant Number and compare if they are an exact match
fill a new column B in Spreadsheet A with the EIN Number.
In order to perform a new data set for the system download
that does not have an EIN Number.
Pu...10.1.2 update and Panther
I've just done a clean install of Panther, when I try to update office
to 10.1.2 the installer freezes at the "Gathering Information" stage.
Any suggestion to solve this issue ?
Do you gave a lot of mounted volumes on your desktop? If so, disconnect
them before running the updater.
All responses should be made to this newsgroup within the same thread.
About Microsoft MVPs:
Search for help with the free Google search Excel add-in:
In article <091120031202560226...Three graph into one
suppose I have
y=e^x [where x=0.5 to 1.5];
and after interpolation I found x ,y values
Now I want excel to plot the graph1 and graph2
with the give function y=e^x (superimposed).
Please help me .
Select the first range and create a chart.
Select the 2nd range, copy, select the chart, and use Edit | Paste
Special... follow instructions
To add y=exp(x), put the x values in 3 cells in a column add the =EXP(x)
values in 3 cells in the a...Combine Data from 2 spreadsheets to create a single Pivot Table
Hello From Steved
I have 2 spreadsheets one is Called Auckland and the 2nd is Called Wellington.
My Objective please is to use the data from 2 spreadsheets to create a
single Pivot Table. Yes this is one workbook with 2 spreadsheets. is this
A person named Fazza shows how on Mr Excel:
I thought this was really cool, and now I'm incorporating it into a couple
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://Peltier...Lotus 123 save as excel workbook and maintain formatting? #2
I have two mailboxes in my Outlook 2003. If I get a message to my 2'nd
mailbox & click "reply" - default set in From field is usernamename from my
first mailbox. How can I change it? I can choose manually by clicking From
field & setting my first mailbox but I would like to fill it automatically.
You'll need to use a 3rd party utility to change it automatically.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlo...I need a four sided program to print on one sheet
I need to make a four sided program, front & back to print on 8.5 x 11 sheet
Okay - so what's your question?
MVP Microsoft [Publisher]
"debbie hughes" <debbie email@example.com> wrote in message
>I need to make a four sided program, front & back to print on 8.5 x 11
debbie hughes wrote:
> I need to make a four sided program,
> front & back to print on 8.5 x 11 sheet
Choose one of the pre-formatted greeting
I have two files in money.
One is Investments, where I record all my Investments
and the other is Bank, where I record all Banking transactions.
Is there any way to combine the two files into one?
Not a good one. See http://umpmfaq.info/faqdb.php?q=90.
"Dutch" <Dutch@discussions.microsoft.com> wrote in message
>I have two files in money.
> One is Investments, where I record all my Investments
> and the other is Bank, where I record all Banking transactions.
> Is there any way to combine the two files into...Combining numerical and drop-down text in a single cell
I am trying to create a medication spreadsheet, and wish to combine
numerical data with drop-down text options in a single cell/column.
For example, I would enter 200 (as the strength of the drug), and then be
offered a drop-down list of the available units (eg mg, mcg, ml, mg/ml etc).
There will be no calculations performed on this column.
Have tried data validation, custom cell formatting and cell merging to no
avail. Do not wish to use seperate columns if possible
I need to copy a formula from one cell to another but I
need it to increase by 7 columns when I copy.Eg =sum
(a1:g1) when copied form cell to another will result in
=sum(b1:h1), but I want it to copy =sum(h1:n1)rather than
having to copy it and then adjust manually. There must be
a way of of copying with constant gaps from one cell to
another. It sounds simple but I cannot find away even by
devising a custom function. Please help
The simplest way to get around this is to insert 6 more
rows after the one you want to copy. Now copy and paste
all seven rows and the formula will jump the ...Cannot update Office #2
Operating System: Mac OS X 10.5 (Leopard)
After downloading the latest update, I get the message: You cannot install Office 2008 12.1.3 Update on this volume. A version of the software required to install this update was not found on this volume.
I have read the advice provided by a responder to a similar query in July but it has not helped. I cannot launch the Updater as seen in that picture and see the update.dmg anywhere.
Can anybody help?
On 3/12/09 12:27 PM, "Spandoc@officeformac.com" <Spandoc@officeformac.com>
> A...The $60,000,000 UP is now ONLINE and FREE to Request! #2
GO TO THE OFFICIAL SITE:
All you have to do is request it. There is
actually no cost to request the UP.
The first ONLINE "Downline Program" that earns
$60,000,000.00 in less than 6 months!
The Ultimate Program has already created many
Millionaires and continues to do so every day!
Before you even consider shutting down this
opportunity, at least take a look at how some of
us ...OL2003 + 2 MSN + pop3 need one inbox
PC has XP SP2 + all MS fixes and OL2003 is current with all MS fixes.
There are three email sources/accounts: 2 MSN(http) connectors and one
The 2 MSN accounts have those special pst files and each has its own
inbox along with the standard inbox that the pop3 account uses.
I would like just one place for ALL the incoming email to arrive at,
just one place to see whether I've got any new email. How can this be
done in this configuration???
Is there anywhere that describes in DETAIL how the MSN Connector works,
how to configure and adjust its operation and what...