I have a set of data(numbers)like 1,60,50,50,44,24,10,15,13,5,15 in a column. Now, I have to calculate the average of ranges 0-10, 11-20, 21-30.... Please...

I have a formula in one cell with several functions used multiple times. It seems though that 25 times is the max for the Round function before it blows up. ...

OK I have zipcodes in column A (a1-a700) and I would like to put all into B1 separated by a ",". so that B1 will have 700 zipcodes all separated by a...

Maybe there's an easy way to do this. A lot of my excel work revolves around data pulled from a live database. I'll have variable length tables. My current...

Hi I'm trying to automaticaly select a certain cell depending on the results of the combo boxes ie: If combo box 1 has a list of names 1-10, and combo box 2...

I hav a large data there is a way of copy a complete row if certain values are in the rows

I have labels in col D (multiple lines but only 7 different labels). I wish to add the cells in col E into 7 seperate totals (according to label). This is the...

I WOULD LIKE TO BETTER ORGANIZE MY FILE TO SUBFILE TO SUBFILE--- CAN I PRINT OUT WHAT I HAVE SO I CAN ORGANIZE IT ON PAPER THEN MAKE THE CHANGES ON MY...

I am trying to merge two columns - one with the date and another with the time so that eventually I can subtract two merged dated/time columns from each other....

Where does one find out in detail about this and other Excel functions outside Excels own help for example, I often see formulas such...

I have a spreadsheet that apparently contains links to about 40 other spreadsheets. Some of these spreadsheets then contain links to others. There is no where...

Hi, I am currently working on a project whereby I enter fractions of hours, and they appear in cells as decimals. So, for example, if I want to enter 10...

I am trying to create a finacial budget calendar. I would like to display creditors, amount due & payment amounts on one sheet and then transpose it into an...

Hi everyone. I've run into a bit of a problem with one of my worksheets. I have a column whose cells are either blank, "Buy" or "Sell" I want the column next...

I wish to create a formula that will return the text "Small Variance Is" if the value of C10 is + OR- ?10, otherwise "Large Variance Is". I know how to do it...

Dear list, I've got a table that looks like this (numbers on left side are row numbers): 1 S1 S2 S3 S4 S5 2 X1 1 0 1 1 1 3 X2 0 0 0 1 1 4 ...

Hi everybody, I need to convert a numeric value to mins(say 2,5 should be 0:02:30.0 which is hrs:mins:sec.decimal) and adding of mins to the time(say...

In Excel 2003, i am looking to show how if a rent ( eg. £200)occurs between dates a) & b) then how to show a 5% increase of that initial rent figure.

I have a worksheet containing various data, including staff names, their start date and the department they work for. I am trying to use an Advanced Filter...

Hi EveryBody, In column C I have numbers 1,3,6,9,12,15,18,21 In column A In have numbers 1 to 21 and in column C I have values corresponding to column B(i.e....