Hi, Can some one please help me? Is there a formular that will take the info off cell b6 sheet 1 and put it into cell e8 sheet 2?

Hello, I have a cell which ontains an IF function. I want the cell to remain empty unless the IF returns a certain value. I know how to use IF, but how do I...

Just got my new Office 2007 Suite of applications. One reason I wanted the new Office is that I work with large data files and the capability of 1 million...

select a cell with a number, then (ctrl) select other cells with numbers... the sum of the cells should display at the bottom, with each additional cell that...

Hi, I have never used excel for math problems before and am having a little trouble with basic equations. I entered the eqn in the function (using the column...

sum displays in the bottom of the work area after dragging across multiple cells?

i want to srt a column in the following order a-1,a-2,a-3 and so on. as of now excel is sorting a-1 ,a-10 a-11 and so on

I have an array with 8 colums and 7 rows. Each column and each row contains a range of values (for example, a column heading is "70% and = 75%", and a row...

Any one able to assist with formulae like the above which for me is quite advanced yet I am sure it is intermediate. I would like to attach a file to give as...

I have a yearly accounting of expenses. The type expense in top row and the months in the 1st column. I have a worksheet for each month and also one called...

I need a formula on one worksheet (such as =$A$22+50) whereas the 22 comes from an entry in a cell. I tried with “INDIRECT�, but did not succeed... Any...

There are 2 data sets are assumed running in A3 and in B3 down, viz.: In A3 down is: A, B, C, D, E, F, G, H, I, J, K and L In B3 down is: B, A, H, C, F, I, K,...

Can any one can help me to solve this I don’t know why I get error #value next to Reference in the Index Function argument window...

I created a userform to accept information from the user. My problem is ,eg i would like the TxtAmount.value to display the amount in Currency when i enter...

I have a large EXCEL sheet that will print in many pages. At the top of the entire worksheet I have a line that says " Address Names phone number " How...

I have started a workbook with each page being a month. On each page, each column being a day. Each column has identifiers (labels) being a sub-catagory by...

I need some assistance with a formula that I have been working on. Here is the formula: =COUNTIF(Agent1!D28,"100") I have gotten the formula above to work...

Hi everibody In column 1 are cells with different values (some cells have 10, other have 100 other have 500 etc); How can excel say "there are X cells with...

We have a workbook which has name in column b we have another sheet with same names but column 1 has id# we would like to have those codes whatever we tried...

Some documents I receive in exel format have sections that I need to respond to then return to sender. Often the spell check option is not available in the...