Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How can I only the cells showing by a filter?19 Dec 2007 22:37 GMT1
If I select to copy a filtered list of cells and pasted to another app, only
the visible cell contents got copied.   If I pasted to another excel sheet,
all hidden cells got copied as well.  How can I only copy filtered cells
within Excel?   Thanks!
Calculate the weekday of last FULL week of month19 Dec 2007 21:56 GMT6
I’ve seen formulas where they figure the “nth” day of the month, but I
haven’t been able to find a calculation that does what I’m looking for.
I’m having a problem trying to figure out how to calculate what a
certain weekday is of the last FULL week of the month.
Need more help with formula19 Dec 2007 21:33 GMT2
I posted the following the other day and received a few answers.
It appeared to be working but it is simply subtracting the two columns
rather then the different bewteen the two dates.
With the formula I was given if I enter in column C3   01/03/2008 and column
how to summarize total number of appearance in a column?19 Dec 2007 20:42 GMT3
Can you tell me how to summarize total number of appearance in a column?
For example, I have a column with three names appear at different rows
another column with value to the names:
   John        45
Underline Button Missing from Formatting Toolbar19 Dec 2007 20:02 GMT1
The formatting toolbar in my Excel 2003 has only two buttons, B & I
for Bold and Italic.
How do I get it to display the U for Underline button?
How do I remove excess pages in Excel?19 Dec 2007 19:56 GMT2
How do I remove unwanted excess pages in Excel 2007? I have a worksheet that
is nine pages long, but totals 18840 pages because I copied some rows. The
unwanted pages only consist of bordering and a header. The size is really
affecting the performance and giving my network ...
merge 2 copies of xml file???19 Dec 2007 18:20 GMT3
i want to combine data from 2 versions of a music playlist , but can o0nly
find help about merging 2 shared workbooks.  can't seem to re-set my xml
files as shared workbooks.  how do i simply merge 2 lists??
Rounding19 Dec 2007 17:25 GMT5
Excel has a function (mround), that returns the entered number rounded to
the number you enter, i.e
=mround(13,5) would return 15, because I told it to round 13 to the nearest
5.
Decimal numbers to time format.19 Dec 2007 17:06 GMT5
I'm sure this is a simple one for you guys but I'm not having fun trying to
get to the bottom of it.
I have two cells:
A1 - contains 47 (formatted as 'number to two decimal places')
sumif help19 Dec 2007 16:16 GMT4
I have a simple sumif formula which I can't get to sum. My current formula is
=SUMIF(M3,"x",F3:G3). What I want to do is check to see if cell M3 has an x
in it; if it does I want to add the values in cells F3 and G3. Now all this
formula does is check for the x in M3 and puts the ...
financial formulas19 Dec 2007 16:11 GMT1
I need help with financial formulas.
SP = Sell Price
C = Cost
GP = Gross Profit
how to set up a simple variable in Excel, but cell location independent19 Dec 2007 15:55 GMT3
Can you please show me how to set up a simple variable in Excel, but this
variable must be cell location independent. Because this worksheet will be
sorted and cell location re-arranged and moved. That mean for example,
In one worksheet, I set variable numb = 5
Tab - motve one cell to righ19 Dec 2007 15:40 GMT5
Tab is supposed to move one cell to the right. Mine moves from column A to S,
to AK to BC and so on. It always moves in hughe ranges. The arrow works,
however, I am used to the TAB and want to continue using that. Ther is
nothing in the set-up screens that would indicate this ...
Data source reference is not valid in pivot table wizard19 Dec 2007 13:01 GMT3
I'm trying to create a pivot table in Excel 2007, something I have
done a thousand times in 2003. However, no matter what I do, the
wizard just tells me that the data source reference is not valid.
I have a table with ITEM NAME, COMPANY NAME, QNT, PRICE, LINE PRICE
Problem with Excel 2003 Template19 Dec 2007 12:53 GMT1
I downloaded a "Membership List" from Microsoft.  It's fine except that the
task pane opens when I open the program.  I have unchecked the task pane
option in tools/options, and tools/customize, and in view.
Nothing works.  How can I stop the task pane from opening?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.