I have a large workbook with a number of worksheets that relate to a template sheet. Is there a way that when I add a line in the template sheet, the same...

I have a number of worksheets with the same data. I would like to be able to add a line to the "template worksheet" and have the same line added to all of...

I am wondering can a 'sumif statement and vlookup formula' be combined to provide a total of a range of numbers or maybe even combined with using 'greater...

I have several sheets that I need to collect data from. Coloumb A has dates Sunday thru Saturday, formated as: Tuesday, August 25, 2009 There are...

Maybe I'm missing a trick here. The formula =INDEX({1,2,3},1,2) will return the value 2 The formula =INDEX(A1,1,2) where the cell A1 contains the...

I am looking for help with a formula. Write now if Sheet1 has a “10� in cell K4, and I put this formula {=IF('Sheet1'!K4="10",1,""} in cell P4 the number...

Please can anybody provide me formular that perform this task below. I have workbook that can contain macro. when i run the macro it pick formular from column...

I have input the following dates into cells A1,B1,C1,D1 respectively...March 30, 2009, August 20, 2009, July 30, 2008, November 20, 2008. Cell Z1 is todays...

I have a cell formatted to show a number as percentage and the conditional formatting rule says Between 0.9 and 1 will be green. 0.9 is showing up no...

My spreadsheet opens in full screen without the toolbars showing at the top. I can use the right click on the mouse to then close full screen which will...

How to reverse data of a single column? Example: Column 2254 245 148

i am using the follow formula to average cells and not average blank cells or a 0.00 =AVERAGE(IF(B2:E20,B2:E2,"")) This portion of the formula works...

Please I have the following: COLUMN A COLUMN B COLUMN C ROW1 500 ...

Why can't I figure this out!?!? It seems so simple.... I have three columns listing GL#, ST# & RL. The last column contains the value to be allocated to that...

I was given this formula =SUMPRODUCT(--(E2:E10="Dawn"),--(F2:F10="X")) yesterday which worked perfectly. I tried to apply a "date" to one of columns as a...

HI all, i posted another one like this but i can't seem to find it here in the group. I need your help with a formula that would be on column d. if b1=b2 then...

I've read almost all of the threads. Now I'm REALLY confused. I need to get an average using data that is put in by the user. I'm adding a bunch of cells...

How can I order a column by the number of incidences of a value e.g. by the number of times a name appears in that column, ordered by greatest to lowest. I...

I have a very large spreadsheet consisting of columns with first names, last names, ID numbers, and other data. I would like to search and copy ID#'s...

I have created a pivot table where i need to change the data frequently and sum up the total minutes per week of an activity. i am using a 'week number'...