I have a row of cells that calculate the totals for their columns but I
force to be blank via IF statements until certain conditions are met.
Once these conditions are met, the total appears. I'd like to also
highlight these total cells via conditional formatting. My conditional
formatting input is simply "If Cell is Greater than 0, format". For
some reason all the cells format as though they are all > 0 yet they
don't display anything. Are there some internal rules that specifiy
when a cell is really 0? Is there another way to do this that won't
care what the for...Reference cell contents
I am working on a spreadsheet that contains various comments from various
sources. I would like take these comments and divide them into different
workbooks by each source.
For example Source 1 = comments in cell C5, C8, & C10
Is there a way to do that in Excel?
...SDI: CDocument data from CMainFrame
I have application which draws lines. I want to rescale that lines when
i change size of my window. Structure of points describing lines is in
my CDocument class. And i handle WM_SIZE in CMainFrame.
There i have to edit points from CDocument. I have:
but when i try:
struct points *tmp=tmp=doc->first;
program compiles but i hangs when i run it.
Does it mean that GetActiveDocument() returns only basic CDocument
object ? How can i access from CMainFrame my data which is in my own
CDocument class ?
It's a bit odd to d...Analysing data from several excel workbooks
I'm totally new to excel and i need to analyse the changes in a funding
position across several years in a seperate excel sheet.
As in, submissions are made year on year showing the amount of revenue spent
on several different services. I need to be able to compare how those have
moved over the last 5 years in a single spreadsheet.
I appreciate any help.
To give a clear answer we would need a bit more detail of the data layout
Give us a simplified version of what the data looks like
Your 'subject' talks about different workBOOKS but the text of the ...recovering data
Money 2000: Is there a way to recover data that was not
backed up. I accidently deleted all deposits. When I
used the restore file procedure all saved deposits were
restored, but all deposits and withdrawals that hadn't
been backed up were deleted. How can I get that work
Retype it all? I mean, seriously, if you type three pages to a document in
Word that you last backed up a month ago, delete the three pages and then
quit Word where are you?
"ETHORN" <email@example.com> wrote in message
news:firstname.lastname@example.org...Managing Data Table
I need help to wrap the tex in Data Table. If any one knows how to do it,
please let me know. Thanks for your help in advance.
What version of PowerPoint are you using? What kind of table is it and how
did it get there (e.g. insert -> table, or a table connected with a graph)?
If it's a graph, is it an Excel graph or an MSGraph graph?
MOS Master Instructor
"Yogesh" <Yogesh@discussions.microsoft.com> wrote in message
news:F68FDA89-6289-4341-8886-54C580...select all data with shorcut key
do u know a shorcut key to select all data, but not to create a table.
usually when i have thousands of rows and columns, if i want to select
all rows i must go to the end of the document and select with mouse
but isnt a fast and easy way to select all data?
If the data is contiguous and nothing else is touching it, you can use:
Lu�s Miguel Ramires Vieira Reis RAM wrote:
> do u know a shorcut key to select all data, but not to create a table.
> usually when i have thousa...Corrupt money data file
I've posted this on the Money UK site but with no reaction ; I wonder if I
can reach a larger audience on here - I'm desperate to sort this out, thanks.
On running Money, I received a message "Money has encountered a problem and
needs to close" - no indication of what the problem was. I couldn't get past
the splach screen
I found article 836197 in the knowledge base which seems to covers this ;
did what it advised, even to the extent of doing an uninstall and re-install,
but ...Not enough system resources to display completely
I am getting this message box more frequently in my Excel workbook. Cannot
find in help topics.
Check out the below..(Might help)
Jacob (MVP - Excel)
> I am getting this message box more frequently in my Excel workbook. Cannot
> find in help topics.
I checked out site and is very helpful but why does it not happen when I
adjust the zoom percentage?
"Jacob Skaria" wrote:
> Check out the below..(Might help)
> http://www.contextures.com/xlf...Export Access Record to Specific Cells in Excel
I'm looking for suggestions on how to export data from an Access table or
Query into specific cells of a Worksheet. The table I'm importing will
always contain a single record only. For example, I'd like to export data
from Field1, field2...etc in an access table to Sheet2!A3, Sheet2!B3...etc.
Any sugestions would be most appreciative.
...Importing data #5
I have a workbook in Excel 2003 that I need some advice on please. The data
used in the spreadsheet is collected online into a CSV file, this CSV file
is imported into Excel onto a "Raw Data" worksheet. From this raw data
several other worksheets need to access this raw data to prepare the reports
required. I have the first report sheet designed and it picks up the data
from the Raw Data sheet. The problem I need help with is updating the raw
data; when I download a new file from our web site and refresh the data
import the report worksheet does not update correctly. Fo...Can't display all text in cell
I'm trying to display text in a cell. I've got Wrap Text on, and I hav
several paragraphs of text. All of it appears in the formula bar, bu
not in the cell displayed on the screen. And yes, I increased the ro
height, but it still doesn't show.
Message posted from http://www.ExcelForum.com
I am having the same problem. Apparantly there is a 1024
character limitation per cel in excel. The only advice I
have received so far, which does work, is to press
alt+enter to create a line break. If you find another
work around, I would be interested.
I have a table "Rates" with the following data:
StartDate: 5/15/08 End Date: 6/23/08 Rate: $53
StartDate: 6/24/08 End Date: 7/15/08 Rate: $86
StartDate: 7/16/08 EndDate: 9/19/08 Rate: $99
I have another table "Transactions". I want to create an append query such
that if I supply the StartDate and EndDate, the query will populate the
"Transactons" table with date and rate data from the "Rates" table for each
and every day within the date range. Example: If I supply the StartDate of
6/23/08 and the EndDate of 6/25/08, the query would pop...How to combine/consolidate data
I am about to create an Excel file that should be used by custmers to place orders. On the first sheet, I would like to have a summary of the entire order, so the customer can see what he ordered.
All data is organized in same sort of tables accross several sheets - each sheet representing different product group.
So, lets say I have table organized like below:
ColumnA ColumnB ColumnC
Product Price Order
Prod1 10 1
Prod3 20 2
And I have several of such tables on different sheets corresponding to each prodcut category.
Now, on the first sheet, I w...Traspose Column data into Row
I want to transpose column data in to row. I have seen many posts (using
INDEX or OFFSET functions) but all these solution assume a fixed block of
data to be transposed, My problem is that the data i have not only has
variable blocks to be transposed but also has some duplicate
headings(headings are duplicate but the data in front of each heading has
different value. Below is the example of data
Col A Col B Col C
PRODUCT COST COMPONENT COST$
A Raw Mat 10
A D L ...Strange behavior when copying formula.
Here is what I'm trying to do. I want to show the summation of the first
two rows' number in the third row. I use the summation function to get the
first result. Then, I copy and paste the result to the other two, but they
show the same results as the first one. I check the formula of all three
results, and they are all correct and referring to the right cells. Why is
1 2 3
1 2 3
2 2 2
Do you have Tools/Options/Calculation set to Manual?
If so, click the Automatic button.
In article <eE#EeXFhDHA.2512@TK2MSFTNGP09.phx.gbl>,
"Leo Leon...Conditional formula 05-12-10
trying to construct a formula for the following for the same cell:
if a2 > 6, then e2 = 0
if a2 = 6, then e2 = 1
if a2 = 5, then e2 = 2
if a2 = 4, then e2 = 3
if a2 = 3, then e2 =5
this is for a golf scoring system. a2 values are hole scores and results
are "handicap" point scores. Any help greatly appreciated
Hope this helps.
On May 12, 4:14=A0pm, desmond1412
> trying to construct a formula for the following for the same cell:
> if a2 > ...Formatting Cells #13
If you want something from cell (A) to appear in cell (B) and change when the
contents of cell A changes, how do I do that?
Acurran, =A1 ???
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
"Acurran" <Acurran@discussions.microsoft.com> wrote in message
> If you want something from cell (A) to appear i...how to create row with data
imagine i have two rows: name and color:
what i want is having, in another row, just the names that have blue eyes,
On Mon, 11 May 2009 17:26:04 -0700, rafael
>imagine i have two rows: name and color:
>what i want is having, in another row, just the names that have blue eyes,
i have excel 2000
what i want is all names in a single row, wi...data import and word templates missing from CRM
Hi. I'm working with a new install of CRM and there are some icons
missing in the setttings area such as the import function on the data
management page and word templates under templates. Any ideas about
why this is?
...Running Access Query Returns Incorrect Number of Records
I am running some code which loops through and runs the queries in an
Access Database. The count of the records is then stored in a
For most of the queries, the figure stored in the Worksheet matches
the number of records if you run the query in Access. But for certain
queries, the count of the records does not match the number of records
when the query is run in Access.
If I change the query to a make table query and then base another
query on that table, the results are correct.
Can anybody suggest running the query from Excel would results in a
different number of records bein...Question with local vs. remote (Exchange server) data
Can someone please explain something basic to me about the way Outlook
works. I'm a Mac user and not familiar with this thing but now need to
figure out how to synchronize it with a PocketPC PDA device.
We've got Outlook on our PCs (W2K), connected to an Exchange server. So,
I see my calendar and contacts, which I know live on the server. But when I
sync my device, it ends up empty. Is there some sort of "local" (to my PC)
data that it's using instead of the Exchange server's info? If so, where is
it and how do I find it? If I could find it, I could copy the Exchan...counting same text from different cells
Hi I was Trying to count text such as "p" for pass from different cell in
excel but i am not sure what is the formula for that.
It will be really helpful if u could send me the solution
"om" <email@example.com> schrieb im Newsbeitrag
> Hi I was Trying to count text such as "p" for pass from different
> excel but i am not sure what is the formula for that.
> It will be rea...pulling cell "value"
in the cell C4 i have the formula =now() and I have that cell formatted to
custom mmmm so that it displays as January.
I am now trying to write some VBA code to look at cell C4 and take the
January and then do a vlookup on the array that i have named months.
months is the cells D14:E25 column D has a list of the months and column E
has a list of numbers that corresponds to these months. This is a custom list
so I can not use the standard numbers that excel uses for the months.
The vlookup in vba should take the January and find the number in col E that
corresponds to it th...Bytes in Data Page Row
I am reading a book titled "Microsoft SQL Server 2008 Internals". In Chapter
6, which was authored by Kalen Delaney, Kimberly Tripp, and Paul Randall, the
following table and Clustered Index is created:
CREATE TABLE Employee(
EmployeeID INT NOT NULL IDENTITY,
LastName NCHAR(30) NOT NULL,
FirstName NCHAR(29) NOT NULL,
MiddleInitial NCHAR(1) NULL,
SSN CHAR(11) NOT NULL,
OtherColumns CHAR(258) NOT NULL DEFAULT 'Junk')
ALTER TABLE Employee
ADD CONSTRAINT EmployeePK
PRIMARY KEY CLUSTERED (EmployeeID)
It states on page 321 of the aforementione...