| Thread | Last Post | Replies |
|
| Re: Weekly Date Function(s) | 12 Sep 2006 01:14 GMT | 2 |
Guys: What I need, I'm sure some body out there knows the answer! If you do, please, please chime in! I want to build a weekly task schedule based of the days of the week (Mon - Fri).
|
| Preserve negative numbers in following macro | 12 Sep 2006 00:57 GMT | 2 |
Ron gave me this Macro which does exactly what I want, except for one small point I have just noticed. //////////////////////////////////////////////////////////////////// Sub Progressive_Error()
|
| Match Lookup question | 12 Sep 2006 00:45 GMT | 8 |
Hey everyone, I am not sure what the best way is to handle this so I thought that maybe some of you could help point me in the right direction. In my worksheet (Sheet1) I have the following data: Sheet1:
|
| Text format & number format | 11 Sep 2006 23:48 GMT | 9 |
I have a cell that is formatted with a macro to change the number 10 to +10.0000 I would also like to add a text letter of g to this same cell so it reads +10.0000g
|
| I want to set up a cell where 1=3 so when I insert 2 it will = 6 | 11 Sep 2006 23:41 GMT | 8 |
I am setting up a Excel worksheet for accountibility and what to simplify it by having one number in a column equal another number in the next cell. I am using Excel 2003
|
| Find part data in row range? | 11 Sep 2006 23:31 GMT | 1 |
Hi. This seems so simple in my head, but I can't figure it out. I have a sheet of data brought in from an access memo field. I've parsed the data into rows, but it's mixed and I'm trying to get it into correct columns on a separate sheet.
|
| My formula's answer is calculated, but disappears | 11 Sep 2006 23:25 GMT | 4 |
I have an excel document here where I have the same formula in a column of boxes. 2 of these boxes look blank, but when highlighted you can see the answer - but only highlighted. How do I fix this?
|
| Formulas | 11 Sep 2006 23:23 GMT | 3 |
I regularly copy worksheets on from month to month then just change the data not the formulas. This time, although the correct formula is in the cell, the formula doesn't work. Any ideas please?
|
| Inserting a space after a comma | 11 Sep 2006 23:20 GMT | 2 |
I have a string of text with commas and no spaces. Example: Sales,Planning,Systems What function do I use to insert a space after each comma?
|
| How do you compare 2 different spreadsheets for duplication? | 11 Sep 2006 23:16 GMT | 1 |
If you have 2 different excel spreadsheets, they have the same column headings and you want to compare the 2 (they are both lenghty 279 lines) to make sure there is no duplication -- what would be the best and most efficient way to do this?
|
| Autosum and Manual Sum not working | 11 Sep 2006 23:06 GMT | 6 |
I want to simply add several rows in a column - all containing currency formatted cells. No matter what I do the total always appears as "0.00". My formula seems pretty straightforward: =SUM(G7:G135). I've researched this for the past 2 hrs. and even had our IT people ...
|
| formula for taxes | 11 Sep 2006 22:33 GMT | 7 |
In need a formula that will figure out someon'es federal taxwithholding on a person weekly payroll: Example: B4 is total wages per week (with overtime included), C4 is % of what they
|
| Change second digit from 4 to 6 | 11 Sep 2006 22:01 GMT | 6 |
Hello from Steved I have 5401 to 5499 and need it to be 5601 to 5699 please If there a formula I can use to acheive the above. Thanks
|
| sparklines for excel | 11 Sep 2006 21:53 GMT | 1 |
Hi NG, Sparklines are tiny charts, a new invention of the info design guru Edward Tufte. You might be interested to check out our sparkline implementation for Excel:
|
| how to i add the first six values of of a row when in various colu | 11 Sep 2006 21:51 GMT | 5 |
How do I add the first nonzero values of a row when they appear in various columns? I only need to add the first six values that are nonzero but these appear in various columns throughout my table.
|