|
how to group a pivot table
My sales guys want to see MTD, YTD and LY columns for their sales data.
I have a database which indicates the month of the sale and the sales amount
and a pivot table which shows the summary. I can group by month and year,
then for last year, I hide the detail which gives me LY sales total. For the
current year, if I hide the detail I can get the YTD number, but not the MTD
number. I...
|
2 |
29.09.2006 18:04:02 |
|
|
i don't want to enter dublicate data in a specific column
i don't want to enter dublicate data in a specific column
please provide me solution for this problem
...
|
2 |
29.09.2006 17:58:42 |
|
|
copy from B worksheet to A worksheet with NO repeated data
hello community
Is there a way for me to copy and paste data from " B" worksheet to " A "
worksheet but those with repeated data be omitted off ? Example:
" A " worksheet " B "
worksheet
A B C A
B C
1 Apple ...
|
2 |
29.09.2006 17:56:52 |
|
|
How can I keep my cursor from being captured in excel?
When working in Excel suddenly my cursor "gets captured" by becoming a plus
sign and no matter where I try to move it it just keeps on highlighting cells
forever. How can I turn this funtion off?...
|
2 |
29.09.2006 17:53:27 |
|
|
My Excel files are not being saved as I put them in.
I am using a shared workbook and every time I save the workbook (I am the
primary user) and reopen, the data is different. It moves things from one
sheet to another, will change information in a given cell. I did run a virus
scan, but have found nothing out of the ordinary. Has anyone else had this
problem? What did you do to resolve it? I can't take the chance that my
data is incor...
|
1 |
29.09.2006 17:44:02 |
|
|
Autofit cuts off part of text when printed
Hi,
I have wrapped text and autofit cells in my worksheet. When I print off the
worksheet, the last line in each cell is partially cut off. I adjusted the
rows manually to enusre my text is not partially cut off, but now, the wrap
text feature is not adjusting the cells to fit the text. Help!!
Thanks!...
|
2 |
29.09.2006 17:40:06 |
|
|
Please tell me there is a way!
There must be a way.
I need to type the Worksheet (Tab) name in cell A1 of Worksheet "A" and
have the data from a specific cell in that Worksheet (B,C,D whatever)
returned to B1 of Worksheet "A". All the Worksheets are in the same Workbook.
The tab names will be differant, and many, depending on the Workbook and
Worksheet "A" will be copied to many Workbooks....
|
3 |
29.09.2006 17:40:01 |
|
|
Error Message
I keep getting the following error message when Excel is opened:
"Cannot use object linking and embedding"
which is followed immediately by the message:
"An error occurred initializing the VBA libraries (14)"
I have removed and installed Office 2003 twice. Excel works OK for a day or
so then the messages come back.
I have checked the machine for viruses and nothing comes back.
...
|
1 |
29.09.2006 17:09:02 |
|
|
2 formulas
Good morning,
is it possible to have 2 different formulas in one cell, and if so, how do I
go about keeping seperate, thx advance...
|
5 |
29.09.2006 16:51:39 |
|
|
PV, NPER, PER and FV
I am trying to simulate some market returns for a retirement investment
portfolio.
I have the PMT function working well.
example:
want income of $250,000, for 32 years, 3% withdraw rate, overall
portfolio value (PV) is $5,097,000.
This is only an estimate- the purpose was to find the aprox value of an
investment portfolio which would yield $250k of income.
On another spreadsheet ...
|
12 |
29.09.2006 16:44:56 |
|
|
How do I create a custom font color in Excel?
I would like to use a custom color in cells in Excel, but I can't seem to
find how I change it to one not pre-loaded into the program....
|
9 |
29.09.2006 16:43:55 |
|
|
how do I deduct furthest south cell from furthest north cell?
example: If I put '3000' in Cell 'A1' and in colomn 'A' there are repeated
numerical amounts being added ie 'A3 50, A8 32, A13 68' what sum would I need
to deduct the furthest south cell 'only' from the '3000' in cell A1. ...
|
4 |
29.09.2006 16:43:08 |
|
|
Autofilter dropdown box doesn't show all the choices in the colum
I have Autofilter turned on in Excel, but the dropdown box does not show all
the options that are listed in the column. For example, in that column i have
3 names listed... Elizabeth, Jason, and Fred. But the dropdown box on the
Autofilter only shows Elizabeth as a choice (alongwith All and Custom). How
can i filter by the names that are not listed... Jason or Fred?...
|
2 |
29.09.2006 16:40:02 |
|
|
How do I display a cent sign
How do I display a cent sign on a table in excel...
|
2 |
29.09.2006 16:38:15 |
|
|
insert a paragraph break within text in a singel cell?
I am trying to enter text in an excel spreadsheet. The text has multiple
paragraphs. I would like to have all text from one section in one cell and
not enter new paragraphs in multiple cells. Are there any manual commands I
can enter to perform this action?...
|
4 |
29.09.2006 16:35:15 |
|
|
Excel 2007 Cube access problems
The Excel 2007 Beta has some bugs/issues preventing many of the BI reports
from working that work today with Excel 2003 and OWC 11 with SSAS 2005.
1. The MDX generated by the Pivot Table uses the MDX Subcube filter rather
than the MDX WHERE clause. This prevents all the time series (e.g.
PrevPeriod) from working. Typical UI tools for SSAS2005 have 2 filter fields
for each type of filter...
|
2 |
29.09.2006 16:25:01 |
|
|
Copying more that one Worksheet at a time.
How are you all,
i was wondering if it was possible to copy more than one sheet at a time - i
have a work book and i need to make multiple copies of one particular sheet,
when i right click on a work sheet tab there are the options there - one of
them is move or copy - when you copy it askes where to put it, when you do
that it only comes up with one extra sheet - is it all possible to ...
|
3 |
29.09.2006 16:23:33 |
|
|
How do I have a cell highlight when selected?
Is there a way to click on any cell either with tab or arrow key and that
cell automatically highlights in a color such as red? This is requested so
that if a person is working in a long spreadsheet with alot of statistics,
they will be able to see the cell that they have selected as it will be
highlights. I tried to create a macro but could not figure out how to make
it automatically ...
|
3 |
29.09.2006 16:17:02 |
|
|
How can I insert the contents of a folder into Excel
Hi everyone!
Does anybode knows how i can insert the contents of a folder of my computer
(as a shortcut or name or path or in any other way) into Excel or any other
Office program for any available use?
T.U.
NP...
|
3 |
29.09.2006 16:16:54 |
|
|
how do i export from excel to outlook
I have been trying to name my cells thought I did but outlook says I have
not. HELP what am I doing wrong?...
|
2 |
29.09.2006 16:12:57 |
|
|
how to make a back-up .xlk file
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/...
|
4 |
29.09.2006 15:59:00 |
|
|
how do i get the average mean of more than 30 numbers?
I am trying to calculate the mean of about 70 numbers, but excell does not
seem to be doing it, it apears that the max is 30#s. can some one please tell
me how to do this, and whether there is a different formula.
Thanks
GV...
|
2 |
29.09.2006 15:45:02 |
|
|
SumIf with discontinuous cells?
I need to use the SumIF (and SumProduct) on a collection of summary row cells
that have sub-component data between them and are therefore discontinuous. A
comma is used to separate these values in the formula, but a comma is also
used to separate the three components of the SumIf formula syntax....so it is
not working. I tried putting extra parens around the range data, but still
doesn...
|
7 |
29.09.2006 15:38:02 |
|
|
Excel file does not deleted
Dear All
Some times what happens that computer get shut down while an excel/ms word
file kept opened. after I restart the computer, file opens as read only and
if I want to delete the file, it does not get deleted , or cant be moved to
another folder or even it cant be renamed. How to tackle this problem
...
|
5 |
29.09.2006 15:23:46 |
|
|
filling a form in Excel... lookup? maybe?
I would like to find a way to pull values (mostly text) from an Excel 2003
spreadsheet and put them into a form in another worksheet. I'd like to find
a way to change the information in the form by entering the client's name and
have the function pull the last entry for that client from the original
spreadsheet.
I vaguely remember there might be a way to do this with the lookup func...
|
3 |
29.09.2006 15:18:03 |