• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by Hui

  1. Hui

    Splitting data from merged cells into separate rows

    Have a look at the second part of this post https://trumpexcel.com/split-multiple-lines/
  2. Hui

    Max per ID (variable number of ID's)

    Z2: =IF(COUNTIF($A$2:$A2,A2)>1,"",COUNTIFS($A$2:$A$14,A2)) copy Z2 down
  3. Hui

    Multiple Regression

    Hi Referring to Post #14 just above These lines Set rngY = ws.Range("B2:B15" & lr) Set rngX = ws.Range("C2:G15" & lr) Should be Set rngY = ws.Range("B2:B" & lr) Set rngX = ws.Range("C2:G" & lr) and RegOutput = Application.WorksheetFunction.LinEst(rngY...
  4. Hui

    Adding XL version

    G'Day All I have found another setting and tweaked that, so not sure if have to log out/in to enable it If it doesn't show up, I dont have God mode access to go further into the setup So maybe a Question for Chandoo
  5. Hui

    Adding XL version

    @all I have added a custom field to User Preferences have a look and tell me what I set mine to?
  6. Hui

    Optimizing Structural Design Calculations with Excel

    Jump over to http://newtonexcelbach.wordpress.com/ I think Doug is a Civil or Mechanical Engineer and does a lot of exactly what your are looking for
  7. Hui

    Efficient methods for extracting data from line graphs in images, especially for larger datasets - Looking for a drag-and-drop solution

    BigJohn This is something I've wanted for ever, and for some reason your post inspired me to tackle it. What I did using step by step below works a treat as shown here ! The Excel file is attached! What did I do I used QGis a GIS Package I setup a new project using a GDA94 Spheroid I...
  8. Hui

    ''Collision'' checking with moving objects in Excel VBA 2019

    Excel should easily handle that for 5 orbs The calcs for all that isn't complex
  9. Hui

    Using VBA to plot data into a custom "chart" using msoShapeRectangle

    In the original post the data was discrete and it was quite permissible for events to overlap In the original post the locations of the shapes represented times and movements You could loop through the shapes and adjust them, but you'll need some logic to define how far? Then you loose the...
  10. Hui

    Locate the Cell which contains the MAX.

    Thankyou VLetm Cross Posting is generally considered poor form, as people don't follow up and close of solutions on all forums. This can cause people to both waste time, and miss great solutions I am sure the OP will not do that here ?
  11. Hui

    getting error this column has more than 10000

    D2: =IF(LEN(C2)=0,"",IF(LEN(C2)=11,"+",IF(LEFT(C2,1)=0,"","0")))&C2 copy down made column D wider
  12. Hui

    Calculate average cost for share transaction with multiple shares in the list

    I think your formula in column F is incorrect F2 should be : =SUMPRODUCT(($D$2:D2)*($A$2:A2=A2))/E2 then copy it down G2: can then become: =SUMPRODUCT(($D$2:D2)*($A$2:A2=A2))/E2 copy it down Please check those manually
  13. Hui

    Cell to be one more decimal place than another cell

    In A2: =ROUND(Your Number or Formula here, LEN(A1-INT(A1))-1)
  14. Hui

    VBA Apply formula but put Value only in Cell

    Startdate and days are named formula They will need to be defined on the other pc also Table 4 must have the same name Also the usercontrols have custom names, so check those exist
  15. Hui

    ActiveX ListBox to be populated

    It is really not clear what result you want? Can you expand the description If you just want to do a lookup, on sheet: Form II, type the following anywhere =INDEX(AFC[Component Details],MATCH(G6&L6,AFC[Concatenate],0))
Back
Top