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

    Explanation of Each line of code to figure out column name (like A,B,C,etc)

    Sorry for the delay. Here,I have attached the file with macro.When u click the breakup button it gives the result X9 below and across.The sum.of total must match with X8 and across with that of below of each column from X9 .The decimal part is not done.Another tab for clearing the data from X9...
  2. P

    Explanation of Each line of code to figure out column name (like A,B,C,etc)

    Hi, I want to do little modification in below code for which I would like to figure out column name.Secondly,I want the modification regarding numbers which is not taking here when the numbers are in decimal like 250.45 i.e it is not subtracting the number after decimal.Hence,taking whole...
  3. P

    Splitting single data

    Ok
  4. P

    Splitting single data

    Plz now find in attachment.Two worksheets,Existing and Required.Required spreadsheet is the expected result sheet.
  5. P

    Splitting single data

    Ok.I will soon come up with all possible cases with some hypothetical/dummy data with real worksheet structure.
  6. P

    Splitting single data

    Dramatic layout would sure exist.This is so becoz,if u see properly,data month 1 is mentioned in both A:D and H:K.But what happens when,I alter month from 1 to 2 in A4. Naturally,data should move from N to P column. Secondly,columns I:J grey cells are useless This is not useless,why ? becoz...
  7. P

    Splitting single data

    With due respect,I will take care from next time.
  8. P

    Splitting single data

    Initially,I thought it would be possible or not.After your #Post,I tested and worked well and was eager to go one step further towards my ultimate goal.:). I hope you can help me.
  9. P

    Splitting single data

    There are no words how to thank u Marc L. I want to go to one step further. I have added 1 more name 'Y'.I have added the manually the result by highlighting in N column.Process is the same as you have done for 'X'. One most important thing, 1.Matching of column C and I 2.I have added month...
  10. P

    Splitting single data

    X is the name that must match with J column.Here,in above post,I have attached file where,I have mentioned the same name 'X'.This would be a matching criteria.
  11. P

    Splitting single data

    Hi,Thanx for the reply. In this case,answer is correct but when I change the value in D4 it gives me wrong answer. Plz check the file in sheets called Scenario 2 and 3.The correct answer I have mentioned manually in O column. I have also mentioned the logic in M column.It will simply take each...
  12. P

    Splitting single data

    Hi, I have in two columns A4=X D4=16 In, K4=2 K5=4 K6=4 K7=5 K8=2 How can I get by VBA (Breaking D4=16 based on K column) L4=1 L5=4 L6=4 L7=5 L8=2
  13. P

    Alternative formula

    Ok. F3 =IFERROR(INDEX('Lookup Data'!$B$4:$B$9,IFERROR(MATCH(B3,'Lookup Data'!$C$4:$C$7,),MATCH(B3,'Lookup Data'!$H$4:$H$9,))),"") G3 =IF(F3="","",SUMIFS('Lookup Data'!$F$4:$K$9,'Lookup Data'!$C$4:$H$9,B3)) If anyone have different formula getting same results I would appreciate further. Link
  14. P

    Alternative formula

    Yeah,it was cross posting.However, recently received the answer.
  15. P

    Alternative formula

    Kindly help me in getting alternative formula for 2013 or lower version till 2007. FILTER(CHOOSE({1,2},'Lookup Data'!$B$4:$B$7,'Lookup Data'!$F$4:$F$7),B3='Lookup Data'!$C$4:$C$7, FILTER(CHOOSE({1,2},'Lookup Data'!$B$4:$B$7,'Lookup Data'!$K$4:$K$7),B3='Lookup Data'!$H$4:$H$7,""))
  16. P

    Search function

    Sorry,it was, Iferror (search({"Apple","Apes"},AC8),"A")
  17. P

    Search function

    I want to correct the below syntax, =if(Search (A8,{"Apple","Apes"},C8,0)
  18. P

    Xlookup+FILTER match & Spill Data

    Ok.Can u figure out what is missing and restate Post#3,code.
  19. P

    Xlookup+FILTER match & Spill Data

    I want simply to match column with another worksheet and get the multiple columns specified.I don't like to match row header.I have mentioned header just to ease the query.
  20. P

    Xlookup+FILTER match & Spill Data

    No,I don't have insider beta version. Plz find attachment.
  21. P

    Xlookup+FILTER match & Spill Data

    Ok.There is another that tried but something is wrong.=LET(z,LAX!C6:R972,l,A3:A1752,FILTER(FILTER(SORTBY(z,MATCH(INDEX(z,,16),l,)),SEQUENCE(ROWS(z))<=ROWS(l)),{0,0,1,0,0,0,0,0,1,0,0,0,0,0,1,1}))
  22. P

    Xlookup+FILTER match & Spill Data

    I want to get data by range lookup and return in array. Something like below. Xlookup (A5:A979,Data!C7:C1120,Data!A7:A1120+Data!B7:B1120+Data!D7:D1120+Data!L7:L1120+Data!N7:O1120)
  23. P

    Extract Unique data based on criteria

    Oh! It was a typo error in 'Expected Result' worksheet when I see the workbook.
Back
Top