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

    How to find a entry against it

    Hi, Can you please explain your requirement in detail?
  2. Asheesh

    Need Formula

    @herofox glad you like it. Normally, single formula solutions are used to avoid duplication of work which saves time as one doesn't need to type or edit the fourmlae repeatedly. Plus, in many scenarios it offers dynamic & robust solution.
  3. Asheesh

    Need Formula

    try this.. SUMIFS($D$2:$D$11,$A$2:$A$11,IF(G2="","<>?",G2),$B$2:$B$11,G3,$C$2:$C$11,IF(G4="","<>?",G4))
  4. Asheesh

    String Search and Extract

    hi, Since it is always 4 digits.. you may even try this for the fun sake. MID(A2,MIN(IFERROR(FIND(ROW($1000:$9999),A2),"")),4) It is almost on the same lines what Bosco suggested Acknowledge with CTRL + SHIT + ENTER
  5. Asheesh

    Need Formula

    Hi, See the blue highlighted cells..
  6. Asheesh

    Multiple Lookup No Repeat

    Hi, Can you explain with an example
  7. Asheesh

    Calculates difference with next cell with value

    here is the simpler one .. Acknowledge with CTRL + SHIFT + ENTER IFERROR(IF(J6="","",LOOKUP(SMALL(IF($J$6:$J$99<>"",ROW($J$6:$J$99)),1+COUNT($J$6:J6)),ROW($J$6:$J$99),$J$6:$J$99)-J6),"")
  8. Asheesh

    Calculates difference with next cell with value

    Here you go !! Frankly speaking, I am not happy with this since I know there must be a simpler way of doing this.. I am working on an alternate solution..will share as soon as I am done. Meanwhile, you can try this: Acknowledge with CTRL + SHIFT + ENTER...
  9. Asheesh

    Congratulations @bosco_yip for your 2,000 + helps ! :)

    @bosco_yip awsome work.. !! and thanks for your insightful posts..
  10. Asheesh

    help needed with countifs and macro. thank you!

    Hi, Count of customer who ordered atleast once in last 3 months.. SUM(N(MMULT($L$2:$N$363,{1;1;1})>0)) Count of customer who have not ordered in last 6 months.. SUM(--(MMULT($I$2:$N$363,{1;1;1;1;1;1})=0))
  11. Asheesh

    How do I account for empty cells?

    hi, Check if the below works.. IF(OR(A1="",A2=""),"",IF(AND(A1<2,B2>4),"1")) If it is not working can you share your file please.
  12. Asheesh

    Data within 1 cell to be split into multiple cells.

    hi Put the below formula in B1 and drag it right and down.. TRIM(MID(SUBSTITUTE(SUBSTITUTE(" "&$A1,"/"," ")," ",REPT(" ",99)),COLUMN(A$1)*99,99)) Attached for ref.
  13. Asheesh

    How to convert year based multi line data in single line for each customer?

    @Chirag R Raval Please apply the formula on the worksheet and share the workbook. I will then go through it and let you know the issue.
  14. Asheesh

    Excel VBA repeat numerical series based on value in another cell or variable

    I have done an interim fix, however, will fine tune the snippet tomorrow. Time to go !! Option Explicit Option Base 1 Sub test() Dim Seq() As Variant Dim n As Integer, x As Integer, ColNum As Integer, sCreate As Integer, tCreate As Integer Dim TotalSeq As Long, nElmnt As Long, p As Long Dim...
  15. Asheesh

    Excel VBA repeat numerical series based on value in another cell or variable

    @paneliyadhruv Did you change the ranges to fit your requirement?
  16. Asheesh

    Merged Cells

    Hi, Welcome to the forum.. Quick Question: Are there any more columns or fields associated to the data..If so can you share the sample please.
  17. Asheesh

    Excel VBA repeat numerical series based on value in another cell or variable

    Use the below macro - attached for ref Option Explicit Option Base 1 Sub test() Dim Seq() As Variant Dim n As Integer, x As Integer, ColNum As Integer, sCreate As Integer, tCreate As Integer Dim TotalSeq As Long, nElmnt As Long, p As Long Dim cell As Range For Each cell In Range("B51:Z51")...
  18. Asheesh

    Excel VBA repeat numerical series based on value in another cell or variable

    Why is series 12345 populated thrice in range AB15:AB29, See image below Shouldn't this be 1 repeated 5 times then..
  19. Asheesh

    Excel VBA repeat numerical series based on value in another cell or variable

    First, welcome to the forum Should the result be something like the attached image..
  20. Asheesh

    How to convert year based multi line data in single line for each customer?

    Another solution using formulae. Follow the below steps: Copy data from Column A to Column J of “Original” worksheet and paste it on new worksheet e.g. “Output” Select Column A:J of “output” tab and remove duplicates. Use the below formula in K2 of Output tab...
  21. Asheesh

    Help Req on - Date Calculation

    I am using the below formula to achieve the result that you already have and in a few cases it is different. Can you use the below formula and compare with your results plus highlight the rows where the result should be different. Also, please mention the reason why should it be different and...
  22. Asheesh

    Help Req on - Date Calculation

    Hi, Can you explain Ex3 a little more, it is not very clear...
  23. Asheesh

    Help with conversion macro

    First of all welcome onboard. Can you share the same file please and the expected output
  24. Asheesh

    Sum Product

    hey @paulcherianc Can you please explain the purpose of matching the date in cell S1 with header in X3:BL3 and then selecting the column AH individually.
Back
Top