Functions
in [Excel]
|
Average IF's Hi Guy's Can anyone help me out with the 2K version of the following plz. =IF($C8=0,0,AVERAGEIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000)) This works great in 2007, but as with most things work related, they don't have 2007 installed. TIA Mark. ... 27 May 2010 22:33
Find and Replace We are using a scanner to input a barcode number into "Find What" box in find and replace in excel. Is there a way to make it stay highlighted for the next input without having to use the mouse to double click to re-select after each input? ... 27 May 2010 17:05
Using a COUNTIF statement with an AND operator I'm using Excel 2003 so I hope I'm not limited here. We are performing a space usage survey and I need to compile the data results. Each location has 70 entries over the course of 10 days. I have a column for "group work" where the value is either 1 or 0. I have another column for # of people observed in a par... 31 May 2010 00:06
Calculation for amt. Exceeding $106,800 for SS Income Limit I'm trying to think of an easy way to work with the $106,800 cap on SS Income and compare this to other types of taxes, such as FUTA Tax and Medicare Tax. I am working on a project to calculate taxes for consultants who make under $106,800 and I can easily roll these up into a PivotTable and subtract out all t... 27 May 2010 17:05
Macro to select last row Try this one liner Range("I2:I" & Cells(Rows.Count, _ "A").End(xlUp).Row).Formula = Range("I2").Formula OR Sheets("Sheetname").Range("I2:I" & Cells(Rows.Count, _ "A").End(xlUp).Row).Formula = Range("I2").Formula -- Jacob (MVP - Excel) "msnyc07" wrote: I am trying to automate putting a sheet ... 27 May 2010 17:05
Two Level Search When you have multiple criteria use SUMPRODUCT() =SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2),E1:E10) If you are using Excel 2007 you can use SUMIFS() to acheive the same result =SUMIFS(E1:E10,A1:A10,criteria1,B1:B10,criteria2) 'or with cells F1 and F2 holding the criteria =SUMIFS(E1:E10,A1:A10,F1,B1:B1... 27 May 2010 17:05
Returning a value if multiple conditions are met Try the below in cell D1..with data in Sheet1 and query values in current sheet A:C.. =INDEX(Sheet1!$D$1:$D$10,SUMPRODUCT((Sheet1!$A$1:$A$10=A1)* (Sheet1!$B$1:$B$10=B1)*(Sheet1!$C$1:$C$10=C1),ROW($A$1:$A$10))) -- Jacob (MVP - Excel) "Joel" wrote: I am trying to develop a method which will return a ... 27 May 2010 17:05
Compile data from several workbooks I have multiple workbooks for different projects. they are all in separate sub folders. Within each wookbook is a worksheet I call Bug. The Bug sheet pulls the data from that workbook which I need in a separate master workbook. I want to pull the data from every Bug worksheet into my master workbook without ha... 27 May 2010 17:05
Having info in a certain cell EXACTLY same as in cell on anotherpa SIMPLY... I want in my summary tab to have the data from A1-P30 to ALWAYS be the data showing on my first page tab that is in position A1-P30.. Once a week I move the data in my first page by moving rows up and down depending on the performance of a certain golfer and what place he now is in overall. This is ... 27 May 2010 17:05
Truth Table WAIT! I think I got it - can someone confirm this is accurate? Sub Macro() Dim lngRow As Long Dim intA As Integer, intB As Integer, intC As Integer, intD As Integer, intE As Integer, intF As Integer For intA = 1 To 2 For intB = 1 To 2 For intC = 1 To 2 For intD = 1 To 2 For intE = 1 To 2 For intF = 1 To 2 ... 27 May 2010 17:05 |