I entered a VLOOKUP formula in a cell using the wizard. In the wizard window, the correct result is returned but when I hit enter to enter the formula in the...

I have a list of dates and I want a function that will return the latest date in the list. Is such a thing possible?

I have not been able to create a macro to open a seperate workbook I am in workbook A and would like to run a macro that will open workbook B -- TS

I started working with an Excel file from the 97-2003. At some point I clicked on save as and saved the document to 2007 Excel Workbook. Since then, I have...

Hi, I am using Excel 2003 is there a function that read a date from a cell and recognize if the date is a holiday? Thanks for help! -- Farhad Hodjat

I've developed a protected sheet in excel 2003. I have protection set to allow inserting rows. Unfortunately, the inserted row doesn't have formulas of...

Is anyone else having a problem with formulas not updating properly in Excel 2003? I have two workbooks. The first one has 21 worksheets and the last three...

I have a pivot table that toggles markets and products with metrics as row labels and weeks as column labels. I would like the dates to be sorted from...

I have an inventory list of corporate bonds with maturities out to 2039. When I sort by the date column, it puts anything with a maturity starting in 2030...

I created the formula below, but its incorrect. If G5=H4 and B5="Case Study", then the amount should be $7000, however, if G5=H4 and B5 = "Video" then the...

Hi, I created a spead sheet and used hyperlinks to link to other documents on our server. This spreadsheet is now archived and has been moved to another...

I have a mixed bag of locked & unlocked cells in a protected sheet. While testing, I tried to delete a row, which was blocked - this was expected. But the...

Would installing SERVICE Packs possibly help the linking and calculating issues? I saw some things in google about it but not sure if I should proceed. Is...

Is there a way to use a formula to determine how many times an alphanumeric value is used in a column of cells. For example a column consisting of 300 cells...

I enter multiple numbers into one cell and they all have to be negative numbers. I would like an error message to occur when a positive number is added. I...

I am creating a spread sheet, for sales. If the amount is $1838 and I need to discount 60% what formula do I use? example: Cell F17 Total $1838 Cell F18...

Hi It would be helpful to be able to filter on any posts that I had made as i often refer back to them, I dont know of a way to do this. Thanks Rob...

Does installing the Microsoft Service pack 1,2 and/or 3 decrease the amount of time a spreadsheet takes to open, calculate or update the links? Also, do I...

hi, trying to find where to post questions for Windows / XP, looking everywhere.. thanks

How do you get the "save as" pop to occur in VBA. Thix way if the save as location written in VBA is not available/working it can go to an error handling...