Recent content by turbodante

  1. T

    Arranging worksheets in alphabetical order

    I can't see a way of doing this anymore elegantly than using the following bit of VBA. Perhaps one of the gurus can improve or come up with a better way. It's does the whole workbook, so you'd have to tinker with the code if you want to isolate only a selection of work sheets to sort Sub...
  2. T

    Solved: Lowest value since

    Just for fun, here's another way, see attched... Though if you're happy with what you have, please mark the thread solved with button at top of the thread. Cheers.
  3. T

    Solved: Lowest value since

    Welcome to the forum thor. Here's a suggestion, in cell C2: =OFFSET($A$1,MATCH(B2,B$1:B2,0)-1,0) And copy down. Hope this helps.
  4. T

    Software for hard disk repair?

    Spinrite from GRC http://www.grc.com/spinrite.htm has is the daddy of all HDD repair/recover, it's not free - It costs $89
  5. T

    VBA whizzes needed for Excel

    Hey slurpee, can you provide a dummy sample so we can assess whether it's feasible. Ta.
  6. T

    Excel 2003: Sumproduct and countif of 2 sheet with same data

    Having suggested that using array formulas could be the way to go, it turns out (after a fair bit of googling) that arrays are not overly accomodating to 3D referencing, like sumproduct. My other thought is to convert both sheets to tables and use MS query/SQL to union the two tables and to...
  7. T

    Formulas to Change Format/ Orientation of a Table

    Tim, Can you upload a sample spreadsheet for both before and after. Please replace sensitive data before doing so.
  8. T

    Excel 2003: Sumproduct and countif of 2 sheet with same data

    I see! Thanks for the explanation, that is one mean formula. In sumproduct formulae, I believe the argument ranges are limited to be within the same sheet – but I think it can be solved using array formulas. I’ve not been able to figure it out myself, but have p.m an expert...
  9. T

    Solved: Array help

    How about if instead of this line... hearArray(I - 1) = Val(Cells(I, "a").Value) use this hearArray(I - 1) = Cells(I, "a")
  10. T

    Excel 2003: Sumproduct and countif of 2 sheet with same data

    Thanks for the example upload Spetar. I still don’t understand the relevance to column A in both sheets. Please help me get past this: In sheet 1, X =4 and Y = 5 In Sheet 2, X =5 and Y =3 Yet in your summary, sheet0; X =4 and Y =3 Can you explain what the formula you have above is doing...
  11. T

    Run-time error "1004": Cannot use that command on overlapping selections.

    Wrapped text should'nt be a problem; but if you mean merged cells - then that could present you with a problem. Personally, I'd avoid merging cells in worksheets:(. To get round this, perhaps you could use... Range("A1").EntireColumn.SpecialCells(xlCellTypeBlanks).Select...
  12. T

    Help with Excel Needed

    If all but one will be FALSE then this should work for you... =sum(C4:G4)
  13. T

    Run-time error "1004": Cannot use that command on overlapping selections.

    Your code works fine for me at the point where you state there's a problem, but for an apostrophie character to comment out your notes. Selection.EntireRow.Delete '[put in apostrophie sysmbol to comment](This is highlighted when attempting to Debug). It may be that you do not have any blank...
  14. T

    Excel 2003: Sumproduct and countif of 2 sheet with same data

    That's lost me. Can you explain how you got that answer again? If you could post up and example spreadsheet, that would help too. Welcome to the forum btw.
  15. T

    incrementing columns with a fixed row in excel

    I'm sorry, but you've lost me. Can you post up a sample so we can see what is going wrong.
Top