I am trying to calculate the total time it takes to resolve an issue within an organization that has a 24 x 5 work schedule during the week and 9-5 hours on...

What is the maximum length that an "IF" function expression. I have an expression that gives and effor message and I think excel is attempting to truncate...

I have a spreadsheet containing several dates. I want to return different text based on multiple criteria. The first criteria is comparing column I to column...

Hi, Is there an option to hide a worksheets tab? If no, can it be done. Thanks..

I have constructed a worksheet that is protected and has unlocked cells for users to wnter information. I need these users to be able to shade these unlocked...

Hi all, Thanks for the previous help. Now i am struck with another problem hope you guys can help me out. My issue is i have two columns like Col1 ...

I have a macro that needs to check the value of a cell in a different worksheet. The cell has a defined name called "mend_tape_cnt". How can I write a...

I have 2 data sheets Sheet one has 3 colums of data A B C 1 2 3 1 3 ...

I have a group of 6 digit numbers starting with "0". When I enter this in the cell, it shows up in the cell correctly. BUT up above the 0 gets dropped. I...

Hello out the I have a worksheet (sheet 1) I need to write a macro that will look at A4:A2500, clear contents of all cells that have a value 140, then...

I frequently debug Excel 2007 add-ins. Once I load an add-in, it, of course shows up on the Ribbon Add-In tab. After I'm done, I unload the add-in, clean up...

HI Everyone I'm working on a Vacation Planner and just can't get it to work. E6 and F6 are dates, G6 is the total of days from F6-E6. The formula below seems...

Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 ...

Hi, I am trying to create a list box in Excel 2007. I can get the list to show, however I cannot get the list items to interact with the rest of the sheet. ...

Is it possible to have a heading that always is at the top of the screen even while scrolling down? If I have a long price list and several columns, and I...

I have a sheet with some numbers in white and some in black. I can use the "find" function to isolate and find the white numbers and then manually add all...

My filter keeps freezing and I have to remove and keep adding until I get a list again. It is occuring more and more often and becoming very frustrating. It...

I am trying to configure a function that will automatically do this: If value in cell D3=P, then insert the value in cell C3 into cell G3. I want to insert...

Using Excel, I want to be able to type in a word and have a formula that is "looking" at that cell return a value (true or false, yes or no, 1 or 2) based on...

Ok my problem is I need to equale or copy a number/value from one cell and put it into another cell that has the "formula", but only if the cell in question...