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

i have data with sold to,ship to ,bill to


New Member
i have data in excel with one columns containing sold to -SP,ship to SH ,bill to BP
i want to entire data based on dynamic selection like i enter sold to it will give me all the data with sold to list
for example
Customer Sales Organization Distribution Channel Division Partner Function
1 XXXX 20 10 SP
1 YYYY 20 10 SH

this data is very big
customer 1 can have sales org XXXX also YYYY .
i would be entering dynamic any one of SP,SH,BP it will give me all the customer with SH or based on dynamic partner function i enter

Thanks and Regards


Excel Ninja
As a new member, You have just read Forum Rules
Please, reread those
Especially How to get the Best Results at Chandoo.org
You'll notice some basic details, which would help You.