Count Dates & Return as %
Excel2003 ... Range C7:C272 contains Dates format = mm/dd/yy (& empty cells) Looking for 3 Formulas for dates occuring as follows: Cell C275 ... Count Dates __ Today () <= -365 Cell C276 ... Count Dates between ___ Today() > -365 & Today() <= -730 Cell C277 ... Count Dates __ Today() > -730 Count dates oc... 19 May 2010 17:10
Adding to an existing Pivot Table
If I have created a pivot table and later add more rows of data to the main sheet (which the pivot table was created from), is there a way to update the pivot table (change the range of cells that the pivot table is referring to so that the pivot table now includes the new rows of data)? ... 19 May 2010 17:10
Is it possible to have a range of cells or an object float while scrolling. ... 19 May 2010 18:17
Will a single quote followed by x mumber of spaces then text negate the trim function? ... 19 May 2010 11:35
... 19 May 2010 14:55
I have this in my column: 858+00.000 R 2 858+00.000 R 2 858+00.000 R 2 858+00.000 R 2 858+00.000 R 2 858+00.000 R 2 859+00.000 R 2 859+00.000 R 2 859+00.000 R 2 859+00.000 R 2 859+00.000 R 2 etc.. This progresses all the way to 1350+00 R 2. All I want to do is remove the R 2 at the end, but keep the n... 19 May 2010 12:42
File in Exclusive Use
I have searched this forum and Excel help and cannot find the answer to my seemingly simple question. How does a user take a file out of exclusive use? We have an Excel file that was shared and the user accidently put the file in exclusive use mode, now we are unable to share the file again. The user does ... 3 Jun 2010 16:48
Data collection in Excel2003
Hi everybody, I created an evaluation form some time ago in Excel 2003. Originally it was sent out to people after they had completed their training. It went out to about 5-6 people so gathering the information was not a very huge task. Now the form has been sent out to over a hundred people and I need to come... 20 May 2010 09:28
How do I find the second highest value.
I have a set of numbers where I need to find the highest value and the next highest value. I can use MAX to find the highest, but how do I find the next one? ... 19 May 2010 09:21
Delete rows that don't contain...
Mike Is it possible to add other choices to keep rows, This works fine for my number range, but I would like to keep 17 and 2 types of text SHS and TFG and then delete all other rows Regards Johnny "Mike H" wrote: Hi, I think your saying that if the number in column A doesn't begin with 10 ... 19 May 2010 07:10