Automic allocation of numbers The numbers represent rounds. So a name will go with a round (number) but some names know more than one round. Name a 1 name b 2 name c 3 name d knows round 1 and 2 name e knows round 2 and 3 Is there an automatic function that would allocate "name d" or "name e" to a round if "name... 2 Mar 2010 14:41 How to sum up the value in column based on a 5 day week period? Hello, Im trying to add the amount of time spent on a type of machinery based on a 5 day week period. For example from 3/1/2010 to 3/5/2010 not including weekends. On the sheet with the data of the amount of time I need added is layed out like this: Colomn A Colomn B Colomn K ... 2 Mar 2010 16:58 excel 101 i need to add thirty days from column A to make column B ... 2 Mar 2010 12:24 counting values in a column I have different values in a a column that I need to count. Column A: 2,25,45,52,25,30,2,45,80,60 and I want to count values as follows <30 = 4 30 and <60 = 4 60 = 2 I have tried countif and sumproduct but it doesn't work correctly. Your assistance is greatly appreciated. ... 2 Mar 2010 13:34 MS excel currency conversion from UK to German Hi I need to convert 1,567.98 to german format 1.567,98 could you please help me how this is done in excel. Thanks ... 2 Mar 2010 10:08 Why font color change back to black when I select a different cell -- CCG ... 2 Mar 2010 03:32 COUNTIF FOR NON-CONSECUTIVE RANGES HOW DO I USE OR SIMULATE COUNTIF FOR NON-CONSECUTIVE OR MULTIPLE RANGES? -- Marty ... 1 Mar 2010 23:11 printing a report I have a course development spreadsheet with several courses. I would like to print a report that lists the courses that are new to development (in the sheet "Development" in Column I, which means a course developer was hired to develop the course for spring 2010) but is also pinpointed for being offered throug... 1 Mar 2010 22:06 Using countif on non-consecutive cells How do I use the countif on non-concecutive cells, i.e. I want to know the number of certain cells in worksheet that contain a specific value. For instance, how many cells in a1:a5, a7, a15:a18 contain the value of 1. -- Marty ... 2 Mar 2010 12:24 Pivot Table 'Validation'? Let's say I have a table, a database, as it were, in Excel. Each record consists of a date, a person's name, and a couple of other things. The name field is validated by a list on another sheet. But not only do I want to restrict the names on the DB to names on the validation list, I expect every name on that list ... 2 Mar 2010 02:27