I am looking for a way to keep track of invoices that are entered on an excel spreadsheet automatically. These invoices are used as quotes and we are required...

The following Formula is what I am using. I get the result of #DIV/0! If I want this to return 0 for this error how would I write the following...

The formula below works ok in the first sheet called "Right-Angled Triangle" In T27 =IF(ISNA(VLOOKUP(S27,Z4:AA84,2,1)),"",VLOOKUP(S27,Z4:AA84,2,1)*P27) Lookup...

Hello, I am trying to copy and paste several columns (some columns have more than fifteen characters) of data into an Excel worksheet. If I try to copy...

Hello specialists! How to place a secondary y axis bar in a bar chart next to, not over, two primary y axis bars? Best regards, Dima

Hello, I have a question about Excel 97. When I used to open multiple workbooks, I would get a seperate icon on the taskbar that I could click on for each...

Hi..I place cell borders on my spreadsheet, primarily to underline columns. When I view print preview, they do not show, nor do they print on the pages when I...

Hello Everyone, I need help... Below is my obnoxious formula. What can I add to it so when I get #DIV/0 It returns a 0...

Morning Have created various dependent lists using the INDIRECT function. What I need is for the user to select from the list looking at the wordy name...

I have concatenated a number of cells to make a formula that I will update data on a weekly basis. Unfortunately, the formula is in text currently, as noted...

Excel: Instead of the figure I typed I get ########. Why?

I am having a problem filtering using the custom filter in Autofilter. I want to custom filter by dates greater than - for instance 1/01/1994. I only get the...

is there a way to make hyperlinks in excell 'relative'? i'd like to copy files without having to change the link. -- tj

Dear all, I found some examples of using Array operation like IF(ISNA(MATCH(... SUMPRODUCT(--(--A1:A100=5)) more advanced of VLOOKUP & Match. to get...

How do you preform an alphabetical sort without formula in cells changing position as well?

You used to be able to highlight all of the subtotals for a given field and with one click and then either shade, change font, etc. and that seems to no longer...

I am looking for a software package that can be used for monte carlo simulations on investments that integrates with excel (e.g., at least for uploading data...

I'm using the Loan Calculator (Amortization Schedule) that comes with Microsoft Excel (I'm running Excel XP). I need to change it so that it will allow more...

I have a worksheet in which several thick black/blue lines have somehow appeared in one of the rows, and no matter what I do, I am unable to delete them. When...

I hope I have the right group for this question. I am Radio Auction Chairman in the Rayne Lions Club in Louisiana and I am working with Excel to enter all...