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...

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 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 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...

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...

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,...

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...

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...

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 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...

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

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

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...

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...

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...

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...

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?

I have two sets of data with the same information but not in the same order and am trying to match the data. In each data set I have 10 pools containing 100...

Hi, I am trying to combine information in 2 different sheets. Sheet one has a column with numbers and a column with titles. Sheet two has a column with the...

I am trying to save a workbook in csv format so that I can upload into another program. The problem I have is that when I view in notebook i have many...