First  |  Prev |  Next  |  Last
Pages: 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159
Acronym Function?
Is there anyway to generate an acronym on cell contents with a function? Ideally I could ignore certain words e.g. of, the, and, etc. and then for the first letter of each word generate an acronym e.g. United States of America = USA ... 11 Mar 2010 16:53
how do i write a formula to add cell contents that are seperated by ten other cells? ... 11 Mar 2010 16:53
The Tueday prior to a holiday...
If I have holidays identified with an H in the A column, I need to find the prior Tues, from the Sat prior to the holiday. Basically I need to find the Sat prior to the holiday, then go back 4 days. I'd like the results to show in the D column like ALERT. Thanks, Steve A B C ... 11 Mar 2010 15:44
Sum Multiple Worksheets, same named cell
I have multiple worksheets containing the same named cell (e.g. Month_Total). On a totals worksheet, I am not able to use =SUM('START,END'!Month_Total) because of the local/global naming. Is there a way around this? (Month_Total will not always be in the same cell on each worksheet). Thanks! ... 11 Mar 2010 23:35
Running Sum
How do I calculate a running total for specific functions? My example is as follows A B C D E F 1 Function: Email Phone Email Faxing Prepping 2 Start Time: 4:25 PM 6:15 AM 6:30 AM 7:05 AM 7:50 AM 3... 11 Mar 2010 14:36
Macro question
I need a macro that will add the text -0000 at the end of whatever text is in that current cell. For example Cell = 75154 I need to add -0000 at the end of this so then it will be 75154-0000 I have tried all the formating stuff, but the Zipcode cell format doesnt work. ... 15 Mar 2010 00:17
Merging different sheets
hello everybody, I have to work with 2 sheets. In the 1st one my data are arranged as follows: Payment Date Type 15/02/2010 XS 15/02/2010 LS 16/02/2010 XS .... ... and in the 2nd sheet: Task Activity XS Activity1 XS Activity2 XS Activity3 LS Activity4 LS Activity5 .... ... 14 Mar 2010 03:19
left/right or center ?
I have days off in the P column in this format: Sat/Sun I'm using them in another column in this format SatSun, so I'm using this formula: =LEFT(P21,3)&RIGHT(P21,3), which produces SatSun However, I have some days off that just have Sun, which produces SunSun. How can the formula be writen to produce SatSun when... 15 Mar 2010 13:30
create a button to print certain tabs in excel 2003
I would like a way to search every tab in 1 workbook and the same cell on each tab, than based an the value in the cell print the page or not ... 11 Mar 2010 16:53
Multiply Cell Values which include text units
I have a formula in cell G13 that shows "=B13*C13". Is there a way that i can multiply cell B13 which has a number format and reads "61 Units" to cell C13 which has a currency format and contains "34.23 / Ea" to get a value of $2,088.03 shown in cell G13? I don't know if I can show text in the cell that is be... 11 Mar 2010 13:28
First  |  Prev |  Next  |  Last
Pages: 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159