Thread: AVERAGEIFS in Excel 2003

I thought that is what youwanted

For the consolidation: http://www.rondebruin.nl/copy2.htm

If you want to get the path of the file the code is in try using ThisWorkbook.Path. I don't know how exactly you would incorporate that into your current code, but that code does actually need 'fixing'. Something like this perhaps. Code: ActiveWorkbook.SaveAs Filename:= ThisWorkbook.Path &"\" & MyFileName

Quote: Originally Posted by gavink Hi Sandeep, Yours works with no error ... Does that mean you modified it slightly first? Or do you not actually have any data like in post #8? If modified, could you post your final formulas?

If MATCH(A4, A:A, 0) ROW(A4) then there is a duplicate of A8 above it. The array MATCH(A1:A100, A:A, 0)=ROW(A1:A100) is an array of logicals, where TRUE means that it is the first occurance of that value in A:A By using MATCH(LEFT(A1:A100,3)&"*", A:A, 0)=ROW(A1:A100), "duplicate" means "has the same first three characters". The data in the above post returns {T, T, T, T, F, F, T} IF(MATCH(LEFT(A1:A100,3),...

Re: Question on VLOOKUP Formulas cannot fetch formats... __________________ Microsoft MVP - Excel

Re: How to add function name to 100 cells without typing in each Find and Replace lenze __________________ If you have to tell your boss you're good with Excel, you're NOT!! All I know about Excel I owe to my ignorance! Scotch: Because you don't solve great Excel problems over white wine

You can but it would require some VBA to transfer the information from one worksheet to the master data sheet. As an example if you set up Sheet1 and Sheet2 with the same headings in A1:B1 (e.g. name/amount) and then enter something into A2:B2 on Sheet1 when you run this code it will transfer the entry to the next available row on Sheet2: Code: Sub test() Dim lastRow As Long lastRow = Sheets("Sheet2").Cells(Rows.Count,...

Re: UDF. If "not a date" set output to "0" Hmm, ok it's becaue workday is dimmed as date.. You can either 1. Dim worday as Variant 2. Or try If workday __________________ The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

Re: Explanation peace of code The first one will try and link to a copy of word that is already open. If there is not one open it will fail and wsApp will be nothing. If this is the case then it is told to open a new copy of word. Note the descreet difference between the two: Set wdApp = GetObject(, "Word.Application") Set wdApp = GetObject( "" , "Word.Application") It will basically use word if it is open if not...