• 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.

Search results

  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

    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...
  7. 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
  8. 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...
  9. 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 ?
  10. 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
  11. 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
  12. Hui

    Cell to be one more decimal place than another cell

    In A2: =ROUND(Your Number or Formula here, LEN(A1-INT(A1))-1)
  13. 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
  14. 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))
  15. Hui

    How to Calculate Previous Year Sales in the attached file

    It works ok for me? Make sure you open the file and allow editing It took a few seconds the first time , then was quite fast
  16. Hui

    I got a real stroke (2nd stroke)

    Bosco With heart felt resolve, Everyone here at the Chandoo.org Forums wish you the best in your challenges ahead. Tackle them as you will an Excel problem, one formula at a time
  17. Hui

    math problems

    All decimals by default are rational As P45cal pointed out, sinmply coun t the number of digits in a decimal and put a 1 in from of that many zero's as the denominator and remove the decimal eg: .5, 1 number after the decimal = 1 zero, add a 1 and remove "." = 0.5 -> 5/10 .15, 2 number after...
  18. Hui

    Why the "Range.Formula = " not work?

    I don't believe that you can do that in a Function You can do it within a Sub Have a read of https://support.microsoft.com/en-us/topic/description-of-limitations-of-custom-functions-in-excel-f2f0ce5d-8ea5-6ce7-fddc-79d36192b7a1
  19. Hui

    Format Source in VBA

    Do a google search on VBA Code Formatter There are a number of Excel addin's that can help you do that Here is an online version https://www.automateexcel.com/vba-code-indenter/
  20. Hui

    Need help with sumif cells containing both text and number

    Can you please attach a file for us to use
  21. Hui

    Chart formating issue

    Select the first chart and Copy Select the second chart Now goto the Home tab, and Select Paste, Paste Special Select Format from the new menu Enjoy
  22. Hui

    XLookup Formula error

    Lisa The two row numbers i have highlighted =XLOOKUP([Order '#],'PS-MARKETPLACE JOURNALS'!$V$2:$V$13595, 'PS-MARKETPLACE JOURNALS'!$A$2:$A$13859) should be the same value
  23. Hui

    Unable to resolve run time error 1004 while using vba to paste data from 1 sheet to another

    Bawaalbro Is it possible for you to attach a sample file with data and worksheets as per your application?
  24. Hui

    How to extract unique values without using unique function

    B2: =IFERROR(INDEX($A$2:$A$1000, MATCH(0, INDEX(COUNTIF($B$1:B1, $A$2:$A$1000), 0, 0), 0)), "") copy down
  25. Hui

    How to extract unique values without using unique function

    Pasadu Please next time, attach a sample file, It takes time to make a file to test, which we can use on other problems Assuming your data is in A1: in B2: =IFERROR(INDEX($A$2:$A$10, MATCH(0, INDEX(COUNTIF($B$1:B1, $A$2:$A$10), 0, 0), 0)), "") Copy down
Back
Top