I'm trying to solve a problem with a formula I'd like to write. I think I'm doing it correctly, but it keeps giving me a circular reference error. What I...

Hi all How do I get Excel to deal with dates before 1900? How about if I wanted to use Excel to calculate length of William I’s reign (from 25/12/1066...

=SUMPRODUCT((ZPODetails!V2:V18172"")*(LEFT(ZPODetails!A2:A18172,4)="3000"))

I am trying to add the Range Name - VATHOBO to NetSalesHOBO to the existing formula below, but can't get the syntax correct. Perhaps someone could...

What is the formula for "coefficient of variation", CV? -- wdy

Is there a way to print (and to print to a file) all the range names and their references for the active worksheet? Thanks

anyone know how to change a nine digit number into a base 32 number? change "347472963" to "abc123" I have found away to convert a 6 charactor base 32...

What's the formula for calcuting the interest on a loan, based on the number of days in the period? I am using a couple of different "loan...

1. Is there a way to do a subtotal and have the results appear in a new column and 2. Is there a way to then sort on those subtotals (high to low)?

Is there a way to insert the value of a cell as a filename for referencing a cell in another workbook? ex: =FileName!$Col&Row where FileName is a...

just trying to calculate my weekly time sheet. thanks

just trying to calculate my weekly time sheet. thanks

Good afternoon everyone. I have a task management table in which three of the many columns indicate the week (Column "A") the work should be done, the person...

If I insert a row with a number less than 074 first, the 074 does as I expect on my spreadsheet. However, if I have it as is below, any lookup to 074 returns...

i am trying to create a timesheet that calculates cells automatically when data is entered. I am entering time "in" and "out" two times (first half of day...

I have a mailing list that has the street number (column A), street name (column B), and street suffix (column C) in separate columns on each row (1037 rows). ...

Is there a way to hide columns based on the password entered? I am trying to go from a Paradox table to Excel and in Paradox there was the capability to hide...

would like to have a sheet where one of the columns has cells which are a self-building list. I understand the need to have any formula or validation copied...

arg... yeah man im pretty much in the same boat ... all i need to do is change the dsn system name :( did you have any luck? "makrug" wrote: I have a...

I would like to save one of my worksbooks as a full-screeen window, without affecting other workbooks or the standard template. How do I do? Is it at all...