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...

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

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

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...

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

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...

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...

Julie - Thank you for that is there a formula where i can have a column titled, name, days attended, cost, paid, balance? how would i set that up so that...

On sheet1 cell F90 I have =Offset('Sheet2'!$E$22,1,0) I'd like to copy F90 to G90:M90 whereby the row parameter in F90 will increase by 1 with each...

I want to insert a formula into my worksheet and copy it down the column without displaying anything in each cell until a value is established. Example would...

Hi Julie, Thanks for replying to my query. But still u have not answered my question. How do i hide rows in a protected worksheet withou unprotecting...

For example, if I have an option of putting a-z in cell A1... in cell B1, I want to pull a list that is specialized based on the information in A1 (A List, B...

I am looking for the Formula or Function to find a cell reference. The range will vary in A6 to A160 with adding and deleting of TEXT - names. What I want is...

I need to SUMIF based on the colour of the text in the criteria cells. Can this be done??

I am trying to create a spreadsheet to calculate hours worked. I need to know what formulas to use to calculate the time in hours and overtime hours. ...

I"m using Excel 2000. The issue I'm having is regarding using defined Names and the SUMIF function. When I set up the SUMIF formula to refer to a particular...

I'm having the sames problem, we've loaded the hotfix and we have ServicePak 1 installed as well and I'm still having the problem. Any suggestions? "Debra...

Hi, I am writing an application using Excel + VBA. I am doing a lot of calculation on data on one of the worksheets and I wish to have this sheet hidden....

i want to input time as hh:mm and add this together carrying the total forward. When i go over 24 hours the figure resets to zero

I use the 'find' key to locate the column I want to make entries in, however the column is getting too long and I have to page down to get to the first empty...