| Thread | Last Post | Replies |
|
| Matching and sorting 2 columns | 01 May 2009 00:19 GMT | 3 |
I’ve got two columns with staff ID numbers which I’d like to firstly match and then sort so that identical ID numbers are on the same row. For example, unsorted the columns look like this: A B
|
| SP2 Move cells slow | 30 Apr 2009 21:53 GMT | 1 |
Since I upgraded to SP2 for Office 2007 I noticed that moving objects using the arrow keys is very slow. This is going on in publisher, Word & Excel. Moving from cell to cell slower than before. Has anybody seen this phenomenon?
|
| Excel 2007 vs 2003 Formula problem | 30 Apr 2009 19:44 GMT | 3 |
Can you point me in the right direction to try and resolve the following issue please? Our engineers use an Excel file to track project progress and we need to submit this weekly to the client for review.
|
| Use VBA to duplicate a row structure/formulas? | 30 Apr 2009 19:27 GMT | 6 |
I'm looking for an automated way to duplicate the last row in a worksheet as soon as it has been edited. I need the new row to be empty but maintain the formulas of the previous row. Is this possible please? I'm working on a continuous form for other users so there's no
|
| Post contents of a cell in the header/footer | 30 Apr 2009 18:59 GMT | 2 |
Is there a way to post the value of a cell in the header/footer of a worksheet. For example, if A1 reflects a short text i.e. a business name, can that name be made to show in a header/footer. Thanks. Michael
|
| How do I average data per minute and per 10 minutes? | 30 Apr 2009 18:50 GMT | 1 |
I have data per 10 sec (Huge COLUMNS) and would like average it per 1 minute and per 10 minutes afterwards. I found some info about 1 hour data averaging, tried to modify it but have to do averaging per each set of data which is way too long... Is there any way to set this ...
|
| Formula results to be copied into a different cell | 30 Apr 2009 18:21 GMT | 2 |
I would like a solution to my problem. I have a formula with a result in "G1". How can I bring over the result into cell "B1"? Once I closed out of the lookup sheet and went back to my original sheet witth the formula results I did copy on "G1" and tried to paste it to "A1"
|
| Excel and conditional Formatting | 30 Apr 2009 17:42 GMT | 5 |
Hey all - I'dd appreciate any assistance on this, i'm a little stuck. Pretty good knowledge of excel, but I can't figure this one out. Here the background. I have a lineup form for a soccer team. I have all the rostered players listed at the bottom. As I enter the exact
|
| EXCEL 2003 | 30 Apr 2009 17:11 GMT | 5 |
Can I take the contents ("WD4") of a cell (A2)on Sheet1, look for a match of the code ("WD4") on Sheet2 in cells A1-A20, and return the coresponding text in B1-B20 on Sheet2 to cell B2 on Sheet1.
|
| HOW WE CAN FIT THE TEXT MESSAGES IN SINGLE COLUNM UP/DOWN WARDS | 30 Apr 2009 15:48 GMT | 2 |
While typing the headlines I just want to fit in the particular colunm by down wards.
|
| need a loan payment schedule | 30 Apr 2009 15:47 GMT | 3 |
I need to show a loan amortization and I don't have a clue what to do. Here's the data. 8.5% interest rate compounded monthly loan amount 47,500.00
|
| conditional formatting | 30 Apr 2009 15:25 GMT | 2 |
this is probably a basic question, but here goes... I have a worksheet where staff will be slowly filling in dates into one column and I want Excel to automatically add into another column the date that occurs 13 days after the original date. I want the cells in the second
|
| "Match" function - erratic behavior in Excel 2007 but not 2003 | 30 Apr 2009 15:22 GMT | 4 |
I have a spreadsheet opened in Excel 2007 with the following values (fo formulas -- values are hard-wired) in cells A3 through A18: 39,814 40,179
|
| problem with stacking charts. | 30 Apr 2009 07:01 GMT | 1 |
I am having a new problem of stacking line graphs in a single figure using data from a pivot table in excel. I was able to do it initially then for some reason when I started a new data sheet, the figure shows a line graph of the second series as double the actual
|
| Excel help | 30 Apr 2009 06:23 GMT | 3 |
Can anyone please help me. I was trying to enter the below no in excel. 0000081563 But when i enter it in the excel cel. it becomes 81563. how can i enter
|