| Recent Answers from Tom Ogilvy |
 |
2008-10-14 Help With SUMIF: Barbara, if you have xl2007, you can do this with the new SumIfs worksheet formula, but I will assume you don't This will work in all published versions =sumproduct(--($A$2:$A$13=9128),--($B$2:$B$13>0)...
|
2008-10-14 Selecting Non contiguous Range: Tim Dim r as Range, lastcol as Long set r = Range("A11",Cells(rows.count,"A").end(xlup)) lastcol = cells(11,columns.count).End(xltoLeft) set r = r.Resize(,lastcol) r.Select r.copy This...
|
2008-10-14 excel comparision: thiru I would use the countif worksheet function instead of trying to do an inner and an outer loop. I would expect it to be faster or at least easier to code: Assumes the actual data is in column...
|
2008-10-13 Transferring Data from Rows: Navneet Sembi assume your data is in Sheet2 with the data starting in row 2 down to row 300 and there are 11 columns of data. Asusme the the product identifier is in column A. on sheet1 in B2...
|
2008-10-13 Macro: the code finds the maximum value, then uses match to determine which of the 6 numbers it is. The error would indicate it can't match that number which may be because there is a formula involved....
|
| More Answers for "Excel" |