Am trying to do a comprehensive cash book, and would like to transfer monthly subtotals to a cash flow planner. Which function is best to subtotal data by...

Hi all, I have a worksheet that has a few vlookups that go on. In the main, there isn't a problem. BUT, every so often, the vlookup returns an error ( i.e....

Hi, maybe someone can help me with a simple "sort" question. I'm using excel 2000, how do I sort in the order that the data was...

I have a if formula that looks to see if a referenced cell is blank (empty cell). If its not, it returns my calculation. If it is blank, I want it to return a...

Hi, I have a column with powers in it another column with light levels in it like: col A colB 23 742 23 674 22 430 22 ...

I have a forecast file in complete numbers, for example $2,000,000; $15,400,000, etc. How can I format the number into $2,000; $15,400 without manually divide...

In March of 2004, someone asked how to make all text characters in cells uppercase. While personally this is something I would not want to do, someone in my...

What is the shortcut to navigate back and forth from worksheet-to-worksheet in the same workbook?

Hi All, Is there a formula to join the following characters to create the example shown below. B2 C2 D2 (End Result) JORDAN ...

I'm calculating retail prices at various gross profit percentages. I do this by dividing the cost by the reciprocal of the desired GP%. I want the results to...

For several years I have used a spreadsheet to balance my checkbook and provide YTD totals by category for a span of the previous 5 years. Each year is a...

I want the sum of a cell from a range of worksheets. What is the formula?

Hello, I am using Example 1 on the following website: http://www.rondebruin.nl/sendmail.htm. The problem is that Outlook is blocking the attachment stating...

Hi I was hoping sombody could look at my formual and tell me were im going wrong. I have a number in I38 and depending on the value (1,2 or 3) it splits the...

I use Excel on a daily basis. One of the biggest gripes I have is that when I'm dragging a forumula from one row to another is that I almost...

Hi Im using the if function, If example A1=B1 insert C1. A1 (text field) has this formula in it =IF((I38=3),MID(H38,1,1)," ") B1 (text field) =3 C1 (text...

Having data below in an excel spreadsheet how can I make a unique formula in column D that gives in lines where the text in Column B begins with "Cap" the sum...

How can I automatically paste hyperlinks from one cell to another ? Ex: I have the names of movies in column A and the URL in column B. I want simply that...

Is there a way to add indicators such as an arrow on a line chart? For example, say I have a cell that contains, "N" and the date next to it (the date is my...