| Thread | Last Post | Replies |
|
| copying date from one sheet to another work sheet | 25 Sep 2006 22:56 GMT | 13 |
I have Date column on sheet1 and i would like Date Columns to propagate on other sheets when i enter this formula on the sheet2 =A1
|
| mutiply by either REG or OT hours, and SUM! | 25 Sep 2006 22:34 GMT | 6 |
I am trying to figure out a way to quickly generate a gross payroll number without the aid of a 'helper' row, which won't work this situation. I have about 60 employees. Sample:
|
| Last column entry lookup. | 25 Sep 2006 22:25 GMT | 1 |
Trying to bring the last entry made in column F (from a checking balance workbook) The formula works OK for the first sheet but doesn't work when I copy it another sheet. =LOOKUP(9.99999999999999E+307,F:F)
|
| How do I insert a drop down list button from an excel worksheet? | 25 Sep 2006 22:19 GMT | 2 |
I an revising a schedulig form and need to create some drop down menus on one spread sheet from data on another worksheet. How do I insert the drop down button on the schedule from the list on the data sheet? I created a list of time options and employee options and need to have ...
|
| Pull last word from a text string in Excel | 25 Sep 2006 22:13 GMT | 8 |
Is there a way to pull just the last word from a text string in Excel? I have a sheet with a column of text descriptions that are various lengths and the last words in each cell are various lengths. Basically I want everything to the right of the last space.
|
| Excel 2007 (Beta) Auto Filter | 25 Sep 2006 22:08 GMT | 1 |
When I had Office 2007 (Beta) installed, I did not like the new auto filtering options. I was used to being able to customize my filter with the "contains", "begins with" etc. options. With the new version, these are not available. One must check mark every instance of what you ...
|
| ADDING A PRINT CONTROL BUTTON | 25 Sep 2006 21:55 GMT | 1 |
I have a work book that i enter everthing on the first sheet and it puts information in the other sheets in the work book. how can i add a button to the first sheet to make the other sheets print there are 7 sheets in total i need for 6 to print when clicking on a button. Could ...
|
| if function and ifblank() function | 25 Sep 2006 21:47 GMT | 3 |
Hi List, Here is what I am looking for: Column A Column B Column C Row 1 1000 Blank(hasF) 100%
|
| Formula not copying down | 25 Sep 2006 21:44 GMT | 6 |
I am currently trying to copy a formula down for a total of 734 rows and across several columns. For some strange reason it stops at 641 rows. Once I drag the formula in, the cell is just blank. I have tried a new worksheet and also tried retyping the formula. Nothing works.
|
| top ten customers by transaction count by product | 25 Sep 2006 21:31 GMT | 2 |
I have a data dump. each row represents a single transation for a product by a customer. There are 15 products represented in the data dump. So product 1 could have 100+ transactions/rows by customer A. And custmer A could have bought all 15 products in multiple transactions.
|
| Removing 1-2 caharacters | 25 Sep 2006 21:03 GMT | 1 |
I have a lengthy licst of names I need to use for a mail merge. The first names are seperated from the last, that's great. however, many of the first names have a mibddle initial and some have a period following the initial. Is there a way I can remove the last 2 characters of a ...
|
| ranking based on criteria | 25 Sep 2006 21:03 GMT | 1 |
I am creating a spreadsheet that shows the results of a marching band competition. The awards are given by class, 1st, 2nd and 3rd place. I will have the following: Name Class Score
|
| calculate the sum of characters in a cell | 25 Sep 2006 20:51 GMT | 8 |
calculate the sum of characters in a cell
|
| How to calculate time after converting 12.22 to 12:22 | 25 Sep 2006 20:37 GMT | 1 |
First I'm trying to enter time (Hours.Minutes) like 12.22 or 123.54 instead of 12:22 and 123:54 for fast entries because I have many of them. Add all of them after. I use the formula in cell A2: =INT(A1)/24+MOD(A1,1)/14.4 to convert in time
|
| Concatenate & Date | 25 Sep 2006 20:26 GMT | 2 |
I am trying to create a macro that saves a spreadsheet to a name based on data in a few cells. For example, if I have Date and ProjectName in two cells, I want the macro to save the worksheet as DateProjectName.csv.
|