Group:  Microsoft Excel » microsoft.public.excel.worksheet.functions

Geek News

Threads Replies Last Post
1263 Pages: <<  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  >>  
count formula
I have a column with dates that I'd like to use a count formula where it counts the total number of rows that match the month and year of a cell. How can I write the formula to calculate this count? Below is an example of what I mean, A1 is the cell that I want the count from Col B to match where the month and year is equal to 11/08. The answer should be 3. Can anyone help me create this f...
6 12/5/2008 4:19:54 PM
How can I delete a series of autoshapes in Excel in one hit?
I have a series of pictures in Excel made up of lines and autoshapes and want to delete them in one hit rather than doing this individually. This is to save time. Is there any way to do this?...
4 12/5/2008 3:00:29 PM
Using workday function to populate schedule
Hi, I wonder if anyone can help. Using the workday formula and conditional formatting I’ve created a Gantt chart in Excel that behaves more or less like a Project file. I have one small problem. The WORKDAY function looks like this: =WORKDAY(D5,F5,C1:D1:E1:F1:G1:H1:I1:J1)-1 The -1 at the end of the formula is there to solve a problem with the Gantt chart. The WORKDAY function ...
3 12/5/2008 10:36:01 AM
Can someone help with this problem please
How can I lock a cell after data has been entered. What I have is a sheet that takes data from another sheet i.e. I have counta to count names. That is on sheet 1. The count remains on sheet 1 and is used on another calculation, but it's also used on sheet 4. There it's used on a different calculation by week number. The problem I have is say on week 1 it's 79, it does it's calculation which ...
15 12/5/2008 8:17:39 AM
Macro File Names
I am trying to create a generic macro that will run a serious of various commands from one file to another file. The trick is "File A's" name changes daily. For instance "File A 12/2", "File A 12/3", ETC.... Is there a way to tell the macro to run off of File A even though the name changes daily? Sub Amazing() ' ' Amazing Macro ' Macro recorded 12/4/2008 by John ' ' Keyboard Short...
3 12/5/2008 6:27:01 AM
Macro File Names
I am trying to create a generic macro that will run a serious of various commands from one file to another file. The trick is "File A's" name changes daily. For instance "File A 12/2", "File A 12/3", ETC.... Is there a way to tell the macro to run off of File A even though the name changes daily? Sub Amazing() ' ' Amazing Macro ' Macro recorded 12/4/2008 by John ' ' Keyboard Short...
2 12/5/2008 6:23:01 AM
How do I ignore "#N/A" data in a column while calculating average
How do I ignore "#N/A" data in a column while calculating average...
3 12/5/2008 5:51:01 AM
Sumproduct & Count formula
Here is my formula =SUMPRODUCT(((ColA=3)+(ColA=4)+(ColA=5))*(COUNT(G3:G52))) Column G contains either text or numbers. What I want to achieve is for the formula to count how many cells in column G contain a number if Column A contains a 3, a 4 or a 5. What I'm getting is the count of Column A multipling the Sum of Column G. And just so you know, Column G has to be able to contain Text. I...
9 12/5/2008 4:49:13 AM
Cell References
A cell in Worksheet 1 contains (by reference) the content of a particular cell in Worksheet 2. If the cell-ID for the referenced content changes (say due to a sort) how do I maintain the link to the content? If 1CellE32 = 2CellX75 before the sort And the sort moves 2CellX75 to 2CellX25 Then I want 1CellE32 = 2CellX25 after the sort Can you help please?...
2 12/5/2008 2:24:50 AM
Evalution of a cell-entry
Cell M20 contains "Whatever". Cell S90 contains "+M20" In order to verify things, in T90, I want to know the row, column, or address of what is really in S90, I mean I want "M20", not the contents ("Whatever"). How can I do that ? (Actually, in T90? I want to make a formula checking whether the column-number mentioned in S90 ("M"=13) is less, equal or greater than the column-number of ...
11 12/5/2008 12:54:24 AM
move Excel cell boundary using sort ?
Wanting to sort rows and want the cell boundary definitions (primarily lines) to likewise move/sort along with its data content. Using Excel 2000. Can this be done? -- thanks William...
10 12/5/2008 12:37:00 AM
HLOOKUP using variable columns
I'm trying to reference a variable column rather than a specific column # in my HLOOKUP formula. A1 B1 C1 D1 A2 1/6/2009 Today's Date A3 1/6/2009 Start Date A4 A5 1/5/2009 1/6/2009 A6 1/5/2009 1 0 A7 1/6/2009 2 1 I would write my formula as =HLOOKUP(B3,$B$6:$D$7,?,FALSE) In place of the ? I've tried to reference a cell that contained a whole number but that didnt work....
6 12/4/2008 11:40:02 PM
Calculating the end date?
I want to create a test schedule. My knowns are the start_date and number of days for each tester. So when I plug in the start_date it will automatically adjust the start and end dates for each tester. Tester 1 starts testing on 12/08/2008 and it will take him 3 business days to test; tester 1 should be done testing by 12/11/2008 (calculated based on start_date and number of business ...
8 12/4/2008 10:33:36 PM
Add Zero Values to Pivot Chart
Would someone please help me with this one?. I'll copy the link to my previous question. The last question was never answered and I would be greatful if somone could help me with this. Hope the link works - I never attcahed a link before.
1 12/4/2008 10:24:04 PM
Display Percentile
In column A I have a list of nuimbers. I ran a conditional format to highlight certain ranges of percentiles (above 80% and above 90%). Is there a way to get column B to acutally display what the percentile is?...
7 12/4/2008 10:21:25 PM
Splitting Data
I have multiple cells within a column that contain text and numbers. I need to split out the numbers. I don't think Data Text to Columns will work because the numbers do not line up. Below is an example. Can anyone save me from having to manually enter these numbers?? Virtualizer for Capacity on Demand - 38756 Virtualizer for High Availability - 38758 Marimba OS Management - 38759...
3 12/4/2008 10:07:28 PM
percentage of individual cell only
I write up service invoices and estimates. I want to be about to put a dollar amount into a specific cell and it automatically adds my 20% to that number - possible OR must use two cells. I don't want my estimates to show that I have a 20% mark up on my part cost and I don't want to have to calculate each time I enter my parts! PLEASE & Thank You......
4 12/4/2008 10:05:57 PM
MSN Money Stock Quotes
After using MSN Money Stock Quotes for several years, we now receive an error when we try to "Update Quotes". Error message is "Failed to get requested data". Have uninstalled Add-in and reinstalled and still get this error. Any suggestions?...
5 12/4/2008 10:15:03 PM
Count Unique Values
I'm trying to count the unique values given several conditions, for example in the example below, count the number of unique Item_num's that were sold on Wed during the Morning, which would return 2: A B C 1: Item_Num Day Time 2: 1 Wed Morning 3: 1 Wed Morning 4: 2 Thur ...
6 12/4/2008 10:20:37 PM
match multiple criteria in both rows and columns
I have looked on these threads for a while now and have come up with 2 different formulas as a result to get what I need. However, both formulas give me the #NUM! error. I have a number of timesheets that are broken out by area, by quarter, and by day. I have a summary spreadsheet that I am trying to sum all of the hours by week and by each area and each quarter. Following are the 2 ...
3 12/5/2008 5:26:00 AM
decision Box Y
How do i put a formula that recognises a 'yes' or 'no' answer? e.g X Y Z 1 10,000 No 0.000 If Y1 has 'No' printed in it then 0.000 is printed in Z1 However if 'Y1' has 'yes' printed in it I need a formula of =sum(X1*0.03) to be completed (see below). e.g X ...
3 12/5/2008 6:38:01 AM
Raw Data - Formatting a Date field
I have system generated file that I work with regularly that provides date and time information like this: 20080919021412.000000-240 I'm having difficulty converting that field to show the following date/time format: 9/19/08 2:14:12 AM Any suggestions? ...
9 12/5/2008 11:25:01 AM
Sum prices 4 object made up of varying number of components
This is for drainage pit. I have been trying to incorporate IF and sumproduct(-- statements and I can't seem to get it right. (Maybe I need to write a program?) I have a large number of pits which will be made up of a combination of a base piece and a number of riser components to make up the height required. The minimum width of pit is determined by the largest pipe to it, according ...
2 12/5/2008 1:50:00 PM
copying data in cells
We are working on a bonus spreadsheet for all of our 10,000 employees. Pages of data were sent to to me to manipulate the data. As you can see there is a row between each employees data; however, when you look at George Jones, his personal ID and name stops on row 1. Is there was away for each ZJ77130 row carry the ID and name down to each row and have it stop on the last row where th...
4 12/5/2008 3:48:01 PM
How can I use the LOOKUP formulas with dates and not numbers?
Hi everyone, I hope someone will be kind enough to help me... this is the data I have: A B C D E F 1 56 1/19/08 12.0 14.8 23 2 98 2/24/08 58.2 21.8 12 3 73 3/12/08 88.2 78.1 08 4 24 9/11/08...
10 12/5/2008 3:54:02 PM
1263 Pages: <<  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  >>  

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net