• 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

    Text to column and copy all data

    thank you so much. this is working.
  2. P

    Text to column and copy all data

    Hi, Would anyone be able to help me separate column H and copy all data to another sheet? Attached are the data and result sheets for reference.
  3. P

    Maximum match column

    Th Thanks
  4. P

    Maximum match column

    Hi, I need to find maximum match from column and return column heading in result. Attached sample excel file with example. Thanks in advance.
  5. P

    Count unique text values

    Hi, I am trying to achieve below result with count if formula but its not working for me. could you please help. below is result. Name Count result A 1 B 2 C 3 D 4 A 1 B 2 E 5
  6. P

    One amount to multiple rows as per criteria

    I have corrected the macro as per requirements. Thanks Marc L for your time and support.
  7. P

    One amount to multiple rows as per criteria

    Hi @Marc L, I have added one more column to this file and made some changes but macro is not working. could you please help on this?
  8. P

    One amount to multiple rows as per criteria

    Superb! Thanks a lot.
  9. P

    One amount to multiple rows as per criteria

    Hi, Can any one help me to get VBA code to split one cell amount and data to multiple/single rows as per criteria? Attached data, criteria and output for reference.
  10. P

    Average formula in Pivot calculated field

    Hi, I am trying to use an average formula in the pivot calculated field but couldn't get actual result. Attached file for with actual result required. Please help.
  11. P

    Adding up positive values in first negative amount

    Hi, I need formula to add up positive value in first negative line in each unique projects, refer attached file for example and result. Thanks in advance.
  12. P

    Randbetween Skip blank cells

    Thanks a lot, its worked as required.
  13. P

    Randbetween Skip blank cells

    Hi, I want to skip blank cells in rendbetween formula, can anyone help me to correct the formula from result cells in attached file?
  14. P

    List of pass names to be extract with formula

    Thank you for your help and valuable time:)
  15. P

    List of pass names to be extract with formula

    Hi, can anyone help me to get formula to get pass names from list? attached sample data with result. Thanks, Pinang
  16. P

    Open amount date required with formula

    Thanks a lot, its working fine :)
  17. P

    Open amount date required with formula

    Hi, I am looking for a formula where I can get date of open balance against each projects. refer attached file for data and result. I have tried many formulas but didn't worked for me, can anyone able to get result with a formula in column G. Thanks in advance.
  18. P

    Pivot table rename

    Thanks a lot :)
  19. P

    Pivot table rename

    Hi, Is there a way we can rename pivot table name on basis of active cell? For example, I have a pivot starting from cell A1 and I want to copy that pivot to cell F1 and rename it using VBA without using reference PivotTables("PivotTable1").
  20. P

    Sum of hours if date range is match

    Thanks a lot :)
  21. P

    Sum of hours if date range is match

    Hi, I need a formula or macro to sum of hours on basis of matching date range and unique number. I have tried lookup formula but its not sum up the value. Attached file for with input and output reference, please help.
  22. P

    Burnout Formula - FIFO(First in first out)

    Thanks a lot! its' working perfectly:)
  23. P

    Burnout Formula - FIFO(First in first out)

    Hi, I require a formula/VBA code to burnout amount in FIFO basis. attached example file for reference. Formula should burnout first month value then balance amount from second month. I need a formula in Range(J3:L8). Thanks in advance.
  24. P

    Insert rows and repeat data

    Hi, I want macro to inset 5 rows and repeat data, attached example file with input and output data. Any code or formula suggestion please.
  25. P

    Verification of date range and provide output

    Hi, I need a formula or macro to find out output result based on name and date range, if name and date range within the input data then display project else show as no allocation. Refer below sample data, attached file for more reference. Input Data: Name Start Date End Date Project A...
Back
Top