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

Lookup and Sort

kme

Member
1."Data Sheet ". Have Table. In This Table Sales Data of Different Group . from This table Need to Pick Another Sheet "Answer Sheet" Same as given left said of the Sample Table "

2. Data Pullout to Answer Sheet Through Formula

3.Extract data based on total sales value from Column H in the Data sheet."

4. Show High Value Sales Of the Group 1st , Omit If Sales Volume 0 Or Blank in Data Sheet Column H

5 Please provide an Excel formula to meet the above requirements
 

Attachments

Back
Top