• 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


  • 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

    Need formula or VBA to weed out unwanted numbers

    If you separate the criteria into 2 cells like Then in BL5 you can use something like: =COUNTIFS(B5:BI5,BJ5,B5:BI5,BK5) That returns 10 So I am not sure how the other checks work with 57 and 4 ?
  2. Hui

    How to Pull Data from a Date Range Based on Criteria

    E8: =SUMPRODUCT(('Daywise''2019'!E2:NE2<=$G$3)*('Daywise''2019'!E2:NE2>=$F$3)*('Daywise''2019'!$C$4:$C$55=$C8),'Daywise''2019'!$E$4:$NE$55) then Copy down Note that the ranges are of equal length/height now
  3. Hui

    Add 'n' numbers from a selected cell in user form pop-up window

    Try these and modify to suit Sub Sum_Range() Dim No_Cells As Long No_Cells = InputBox("Please enter the number of cells to Sum", "Sum Range") Dim sum_rng As Range Set sum_rng = Range("A1:A" & CStr(No_Cells)) Dim my_sum As Double my_sum =...
  4. Hui

    Multiple Combo Lists

    Anon1mous Please attach a sample file
  5. Hui

    How do i group dates automatically

    Assuming each group is 5 days long starting on 1 April 2018 In cell B2: =INT((A2-DATE(2018,4,1))/5) copy down
  6. Hui

    12 month rolling data - How do I produce a single arrow Icon to represent the total trend.

    Pivot Tables in Excel 2019 have the option somewhere to lock the formatting
  7. Hui

    How to create/generate a licence code for my excel file.

    There are a few systems around that will replace variables with words like ababababbba and abababababa Which makes reading and decythering very difficult, but not impossible
  8. Hui

    Dynamic formula again.

    First, I'd go away fr5om Week Numbers to dates. Why what happens to the dates like 30 August? Second, E4: =IF(AND($C4<=F$3,$D4>E$3),$B4,"") Third: Fix up the Month Tiles, to align with the months better See attached
  9. Hui

    How do I return a Yes or No response?

    =IF(COUNTIF(A1:T1,"<>")>0,"Yes","No") That is a <> with " around them, no spaces
  10. Hui

    Happy 10th Anniversary Chandoo.org Forums

    Today on July 26, 2009 the Chandoo.org Forums were turned on. So after 10 years, 39,144 threads, 246,519 messages and with 51,201 members a big Happy Anniversary is in order Happy 10th Anniversary Chandoo.org Forums I look forward to the next 10 Hui...
  11. Hui

    Future date

    Thomas You are trying to make an Array based on Today() and a number of months ahead of that, and then lookup the value of A2 in that array Unless they conicide it will not match Shouldn't C2 simply be : =EDATE(A2,B2)
  12. Hui

    How to replace the zeros of an array?

    =if( {0,0,6,7}<>0,{0,0,6,7}) Ctrl+Shift+Enter
  13. Hui

    Create report from the table by the format of the cells

    I would look at Peter's example and work through the data flow that you need, see where/how it is handled in Peters model There are times where Names don't appear as simple as maybe you think it should be But the logic of what peter Has setup is flexible and extensible in that it allows you to...
  14. Hui

    Create report from the table by the format of the cells

    Daniel taught that Names are actually more correctly Named Formulae and that all Named Formulae are Array Formula ie: A100 is actually a Named Formula referencing some memory that has a value or formula that you associate to a logical grid position of A100 Daniel went into great lengths in the...