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

Change of batch period

Thomas Kuriakose

Active Member
Respected Sirs,

I am struggling to get a display of batch numbers which have moved from Change Type 1 (PP) to change type (A1,A2,A3) as well as change type 2 in the attached file.

I tried to prepare a pivot table, but the value fields does not have text to summarize.

Kindly guide on how to get the result as detailed in the required result tab. The example listed is for PP to A1 and Change type D.

Thank you very much for your support always.

with regards,
thomas
 

Attachments

  • Batch change period.xlsx
    530.7 KB · Views: 7
Respected Sir,

Thank you very much for this solution provided.

This is working correctly.

Sir, there is no code in the editor, how is this done.

Thank you very much once again,

with regards,
thomas
 
Back
Top