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

Help in comparing charges on 2 different dates


New Member
Hi All,
Need to capture Special deal and standard deal separately against charge number available in week 31 report sheet by using following steps:
Need your help with the attached, I need rates for charge number and charge type for 2 specifics as I need to show variance in rates if calculated on PCD (highlighted in green) basis and Discharge date (highlighted in green)
There needs to a unique ID made combining Charge Number, Charge type and Commodity (highlighted in yellow)
If the date falls in between the active date range then we need to copy the entire row against that charge number or unique id.

Sharing sample data attached as actual data is huge.