| Thread | Last Post | Replies |
|
| How can I only the cells showing by a filter? | 19 Dec 2007 22:37 GMT | 1 |
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 month | 19 Dec 2007 21:56 GMT | 6 |
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 formula | 19 Dec 2007 21:33 GMT | 2 |
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 GMT | 3 |
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 Toolbar | 19 Dec 2007 20:02 GMT | 1 |
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 GMT | 2 |
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 GMT | 3 |
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??
|
| Rounding | 19 Dec 2007 17:25 GMT | 5 |
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 GMT | 5 |
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 help | 19 Dec 2007 16:16 GMT | 4 |
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 formulas | 19 Dec 2007 16:11 GMT | 1 |
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 independent | 19 Dec 2007 15:55 GMT | 3 |
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 righ | 19 Dec 2007 15:40 GMT | 5 |
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 wizard | 19 Dec 2007 13:01 GMT | 3 |
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 Template | 19 Dec 2007 12:53 GMT | 1 |
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?
|