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

Recent content by hardeep.kanwar

  1. H

    Highlight Duplicate using conditional formatting

    Hi Expert Can i highlight the duplicate using CF,I know how to highlight duplicate if value is single,but problem is i have 2 value with delimited with "/" Few examples for your reference,see highlight with RED Invoice No DODI18090410 DODI18090410 DODI18100200&DODI18100393...
  2. H

    Top Rank (50% of Row Total)

    updated with raw data
  3. H

    Top Rank (50% of Row Total)

    File Attached
  4. H

    Top Rank (50% of Row Total)

    Hi!!! I have data Zone, Outlet, and Sales and I Create Pivot Table from this Data I need those Top Outlet who have Contribute 50% of the Total Sales against Each Zone. For example, if Zone A has 10 Outlet and their Total is 127, what I need to highlight or who have achieved 50% from the...
  5. H

    If Formula from Drop down

    Thanks a Ton Dear This is what i am looking
  6. H

    If Formula from Drop down

    Hi Thanks for the Reply I am Attaching the Sheet for better Clarification Conditions are : 1: If R5 is Equal to J3 and K3 than Calculate the 9% of H5, L4 Remains "0" 2: If R5 Is Equal to L3 than Calculate the 18% of HG, J4 and K4 remains "0"
  7. H

    If Formula from Drop down

    Hi!! I am using IF formula using Drop Down. Drop Down List 1: SGST/CGST 2: IGST Other Condition in J3,K3,L3 i.e. SGST@9% CGST@9% IGST@18% RespectivelyNow i am using below Formula for IGST@18% its working and calculate the Value fine Formula is for IGST@18%= =IF($R5&"@18%"=$L$3,$H5*18%,"0")...
  8. H

    Date Format Issue Combining Text and Date

    That's Cool
  9. H

    Date Format Issue Combining Text and Date

  10. H

    Date Format Issue Combining Text and Date

    Thanks for the reply Thanks for the reply but its not working m getting below result after Change the Value to DAY(TEXT(TODAY()-3 Updated Joyride Program Summary Till Dated - 23th-Jul-2017 Cumulative
  11. H

    Date Format Issue Combining Text and Date

    Thanks for the reply but its not working m getting below result after Change the Value to DAY(TEXT(TODAY()-3 Updated Joyride Program Summary Till Dated -23th Cumulative
  12. H

    Date Format Issue Combining Text and Date

    Hi All i have formula "="Updated Joyride Program Summary Till Dated -"&TEXT(TODAY()-1,"DD-MMM-YYYY")&" "&"Cumulative" and the result is " Updated Joyride Program Summary Till Dated -25-Jul-2017 Cumulative " What i need to Add "th" or "rd" after the Day For Example 23rd or 25th or 22nd...
  13. H

    Vlookup or Indext Match with 2 Criteria

    omg, How should i Forget Sum product Function Thanks a Lot Mike
  14. H

    Vlookup or Indext Match with 2 Criteria

    Thanks Shaikh Saab Kamal Kar diya aapne to, Thanks again
  15. H

    Vlookup or Indext Match with 2 Criteria

    Hi All, Is there any way for get the Value in another Table or Sheet, Using Vlookup or Index match Function Where the Criteria is More than 1
See more
Back
Top