I have a chart and it uses a forumla to retrieve data, and if no data is available it sets the cell to "". My problem is that when I try to print the...

Hi, I have a problem when using the offset function. I am using the Match function to find the first and last occurences of a string in a series of data. When...

I have an Access database that I do a query on. When I select all and copy the query table, then paste into a pre- existing workbook, the functions don't work....

I am trying to create a survey...80 questions with 3 options for each. So next to the first question, I inserted 3 option buttons and then did the same for...

After 20 years of manually assigning payment formulas to dates in my cash forecasting models (it only has to be done once a year), I am tantalisingly close to...

I need some help using the date and if functions. I need to add one year to a date(hire date) and then if the result is earlier than a date I have input...

I have recorded a GoalSeek macro in Excel 97 SR2, which works when called from the Tools | Macro menu, but when I call it from a button on the spreadsheet then...

Assume the following sheet, with columns titles Color, Yesterday, Today Blue 5 7 Blue 0 9 Red 3 9 It is...

What is $5 and 15 minutes when it can make you earn $100,000 ? Not much, if you ask me... You've probably seen a lot of those kind of messages over forums and...

I have a sheet that looks like: A B a 1 b 2 c 3 =vlookup("a",A1:B3,2,0)=1 =vlookup("b",A1:B3,2,0)=2 =vlookup("c",A1:B3,2,0)=3

Dear All I would like to do the following via a formula/formulas if possible, rather than using VBA. I would like to allocate a given value across its relevant...

I need to return a result based on two criteria. When matching each of the criteria, there will often not be exact matches. So, the match should be one the...

I have 2 worksheets. I need to compare the cells in column1/worksheet1 to the cells in column1/worksheet2. If a cell in column1/worksheet1 is nowhere in...

I am in a workbook with several sheets. While working on one sheet I selected 'new window'. I would like to delete this extra window, how?

How do I make a cell change to a certain colour, without affecting the number that is already in it? I run a lottery Syndicate using a simple workbook with 2...

I was working on an excel 2003 spreadsheet, in Windows XP, and I had to check an email for billing purposes. In the email there was a another spreadsheet that...

I need to find the present value of rental income that is discounted at 5%. I need to show each year separately but when I do the formula, I believe I have to...

Hi I need to create a macro that will first do a "save as" picking up a file name from a cell on the worksheet and then will exit excel

I want to apply conditional formatting to cells that are blank depending on if other cells have text or numbers in them. For example: If cells A1:A5 have...

I simply can't figure this out... I have multiple locations that I need to find specific criteria and sum: A B C ...