When I count calendar days, using =VALUE(B2-A2) or even just =(B2-A2), it always omits one day. For instance 28/09/2009 to 30/09/2009 the formula counts it...

Hello, I have a problem in Excel, I've basically done alot of forms and text but after a while I realised, when I changed the value, the formula which uses...

I want to merge two sheets and use the merged data in a new sheet. Both my sheets contains similar info but there are fields that differ. I need Column A...

I have two spreadsheets that I need to merge. One has the student's name and ID number, and the other one only has the ID number. Is there a way to merge...

Hi I am using excel 2002. Our company has just converted to SAP and I am attempting to set up Templates containing Pivot Tables. I created a Template using...

I have a calendar and in the Friday column I want the cells to reformat if they match a range of dates located elswhere in the spreadsheet. The application is...

We have LOW prices on King Edward Cigarillos. This is a great cigarillo top brand name with a great flavor. Interested in King Edward Cigarillos, then visit...

Using Excel 2007. I am not sure if I am trying to do is too ambitious. My single column sheet looks something like this A1 abc abc, def abc, ghi def def,...

I'm trying to count how many times the word, "false" appears in a coloumn range of: F1:F2500 I've formated the "F" coloumn to analize and put either a, false...

I am facing this issue, need someone to share how to get the hyperlink working on excel 2007 if i hide or hidden the worksheet.

Hello-- I have a series of columns for which I'm trying to find the column header for the max value. For example: A B C D...

I am trying to return the name of a person who worked the most hours in my volunteer table. The columns include the person's name, date worked, number of...

I apologize if this is a duplicate submission. I have a spreadsheet of data with two columns of data for which I need to summarize on another spreadsheet. ...

The Autofilter option is not available in the sheet I am working in. It is grayed out. The file is not protected. Any ideas? (I'm using 2003)

I have a pivot table that source data is always the same, but I delete the old data and copy in new data. A field in the data and used in the pivot table is...

I’m working with a worksheet using Web Excel or CPM (Everest). As such I’m combining functions from excel and web excel. Web Excel recognizes dates in...

I'm trying to write a formula so that if the date doesn't match, say the current date, that it will take a month that I specify and give me the last day of...

Hi Can you tell me how the macro looks like if I would like to import to Excel spreadhseet all txt files from specific folder starting row 1? -- Greatly...

How do I change the font properties in a check box? I would like to have the font bold and a different color. Thanks Irie!

In Define Name in Excel 2007 I want to create a formula for A:A that excludes duplicates in the range. How do you create this formula.