Is there a way to increment the Row Number in a formula or a better way to sort my data. On sheet 1 I have data for multiple items that is imported from a...

I need to make an attendace sheet and I would like to add up the absences ONLY (only the columns (cells) with an "A" in them, other columns may contain a "P".)...

I need to know how to put multiple aurguments in the countif statement. I want to look at a range of aging days and count everything 0 and 30 days. Any...

Hello Group, I am using the rank funcion in excel 2000 but it doesn't give me an ordered (1,2,3....) rank. I also tried the % rank, first but the...

I have a file a friend is having trouble with. He put =t5 in cell u5. It returned the value in t5. He then drags the formula down to u20. Although the...

I know I've done this before in Excel. I want to round to the nearest 5. So 462 = 460 and 463 = 465 I tried round(A1,-1.5) and obviously that doesn't...

I would like to be able to have a column total numbers as I type them in. e.g. in column A1, I type 12+12-3. When I hit enter I want the total of 21 to appear...

I have two columns in a table that are imported from another table, and then I have specified dynamic data ranges for them using Insert..Name...Define and I...

Hello All- I am working on a price book in Excel 2003. The price book includes UPC-A codes. Our number is 0-51943-XXXXX-X. We have approx. 250 different...

i wish to program into a spreadsheet a formula that will be solved by using the results of many smaller formulas and constants ie Qh = hc(ts-ta) and hc...

I would like to create a formula to give me the number of cells that meet two criterias: Employee Department Number (e.g., "210") AND Employee Location (e.g.,...

Hi JC, Try this: I assume R1CA is A1, R2CA is A2..... A1 formula =Sheet1!D10 A2 formula =OFFSET(Sheet1!$D$10,(ROW()-1)*30,) Copy down as needed.

Does anyone know how to set up a macro that will automatically set the print area to a changing number of rows? For example, if one list has 20 rows of data...

OK, since everyone and her/his brother and sister have renamed themselves "=?Utf-8?B?VFM=?=" it is hard to tell, but this is the third or fourth request for...

In R1CA, enter =INDIRECT("Sheet1!D"&(ROW()-1)*30+10). Copy as far down column A as desired. -- Regards, Tushar Mehta, MS MVP --...

OK...who knows how to make Excel take each data point and give it equal value. Thanks, Greta

I have a spread sheet with colum "A" contaning 145 rows of data. In this range there are 12 different products in order of when they were purchased. In column...

I have created a table that looks something like this: Column A = Class Number Column B = Option Number Column C = Number of Voters Column D = Amount Total of...

Can someone answer my question? I have a spreadsheet that, when printed or viewed in print preview some of the text is cut out. It is as if a block is covering...

when i use the function ACCRINT(),I meet a...