Hi everyone, I don't have a financial background so pardon me if the answer is obvious. I see Excel is loaded with financial functions and I'm not sure of...

hi, I have "inherited" a bunch of excel files which have been written with a cell containing the TODAY() function, so when I open them they always change the...

Hi, hope you can help. I have a number of named ranges across a workbook. In 1 summary sheet I want to be able to enter a range name and then other cells...

I have to calculate markups on a net amount of cost so that the first markup will be 10% for the first $10,000. Than the next box will be a markup of 5%...

How do you assign anohter Excel file as the source for the pulldown list?

I have created a workbook with an extensive custom menu. I now need to transfer the workbook to another computer to be used elsewhere. When I transfer the file...

Hi Abdul, You can use the below function to count the days. First though, you will need to copy the code at the end of this post into a VBA module. ...

I have workbooks containing many protected worksheets. I would like to set up an index page that shows the name of each worksheet and its current status -...

Occassionally I find that when I use VLookup I get the row number of the item within the lookup range instead of the value. It's not clear that I am...

Is there any reason this shouldn't work work in Office 2007, with a TextBox directly on a spreadsheet rather than a form? I can't get this to work and...

I have two suggestions to improve VLookup: 1. Add an optional parameter that provides a result if the Vlookup returns NA so that you don;t need to wrap it in...

Hi, I'm looking to calculate the differnce between two numbers, Say I have 24 in a columnand next to it in the next column I have 25, I would like it to show...

A co-worker of mine has a question pertaining to Microsoft Excel 97. She is wondering if, if the same text appears in both an Excel spreadsheet and in a chart...

I am a quantitative analyst who is the leader of our department's Excel users group (Multi-Channel Marketing department of Eastbay, Inc. in Wausau,...

Hello: Is it possible to make the pivot table format not change? It was because I have change some of the color on Cell but it will change the format when I...

Hello: I would like to group the date into one cell. Would you mind to give me a help? Source Data! only one...

Hello: Would you mind to tell me is it possible to find the average on every day with the following data? Date ...

Hello: I have problem on how to calculate the daily average! Would you mind to give me some hints? Raw Data format! "Time","Free Megabytes" "08/01/2003...

My spreadsheet has a column which contains data which can have more than one occurance. I have grouped each occurance of the same value together and then...

How do I sort the data in the columns, I want to make them appear in alphabetical order? It is a list of DVDs with some of the actors. I've just tried to...