Does anyone know a formula to add the number of hours worked each day using a format of #am-#pm or #am-#am or #pm-#pm. I am making a weekly schedule for 15-20...

I need to insert a dash at several different points in a text string. Does anyone know a function that will do this? Any help is appreciated. Thanks

How do I set up a pivot table across multiple pages of data? My lines of data total over 70000 and therefore are contained on multiple worksheets. I was able...

I have a spreadsheet that has a couple of hundred named ranges in it that I need to delete. Is there an easy way to do this or am I stuck in the Define Name...

I am attempting to use a Purchase Order template for employees and want the template to automatically assign sequential PO numbers by asking the employee to...

Hello! I have one column of names, address, etc. 6 rows per person...so, every sixth row is a new person/contact. I can go down contact by contact and...

I would like to apologize for my lack of knowledge of excel. Let me explain my problem: I am working with an excel workbook in which one sheet...

=IF(Enter!C2:C1690=March,SUMIF(Enter!$B$2:$B$1690,$A9,Enter!$D$2:$D$1690),0) Enter! - is my sheet with data C column contains dates B column contains account...

Hi to All, I want to do a double vlookup, where I want to bring back cost_of_sales to sheet 1, if the location and item# from sheet 2 matches with the...

I need to average agroup of cells but IF the total is "0" in one cell then I do not want it to be average in.... How can I do this.... Exp. Average cells K13 -...

I have a formula...LEFT(D2,FIND(",",D2,1)-1) Basically it takes Civic Memorial Field, Somwhere, NV and gives me only Civic Memorial Field. However when I use...

Hi, I'm trying to download from yahoo finance the Historical Prices for some European stocks, for instance perp.pa, and in the browser I can see all the...

How do you printe all the data in a cell. Excel only visibily displays up to 1024 characters but you can have more data than that. How do make excell print the...

Hi to All, Hi, I want to do a double vlookup, where I want to bring back cost_of_sales to sheet 1, if the location and item# from sheet 2 matches with the...

I'm trying to copy the result of a particular formula to another sheet within the workbook. I need to set this up within a macro, so that the weekly results...

Dear all, I have a cell A1 which contains some text which is a concatenation of texts in 2 cells (The formula is =CONCATENATE(A2, A3)). The texts in cells A2...

Simply put, I need a function that will indicate if a given date is a workday or a weekend. I could also use a function that would given me the networkdays in...

I am trying to create a table of numbers using the formula: =(B1-A2)+11. I want the first value to always come from Row 1 and the second value to come from...

Are you aware that this is an *array* formula? Array formulas are entered using CSE, Ctrl Shift Enter, instead of the regular Enter, which will...

How would you advise going about the following. I have a column for project start dates. I have another column indicating duration for the project in terms...