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 ...

i don't want to enter dublicate data in a specific column
please provide me solution for this problem

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 "

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?

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.

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

I am trying to simulate some market returns for a retirement investment
portfolio.
I have the PMT function working well.
example:

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.

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.

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 ...

How do I display a cent sign on a table in excel

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?

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

I have been trying to name my cells thought I did but outlook says I have
not. HELP what am I doing wrong?

----------------
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