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

Multiple Criteria and multiple result

ssj011

New Member
Good Day,

Need excel formula to get the result based on some conditions

  1. Have Input table where we have data for deals basis contract ID, location and Charge type
  2. Want to find how many deal field for specific contract+location+charge type+ Date
  3. Basis this 4 concatenate want to check how many deals are available in the input table
  4. If there are multiple deals then all deal should be given in output table
  5. Gave some sample for your reference
Do let me know if you need any more information.

Thanks for your assistance and support.

Regards
Sachin Jagdale
 

Attachments

  • PCD Data.xlsx
    13.6 KB · Views: 8
ssj011
Are Your Outpur -table results correct? eg Cell N3's 15-Aug-19 ... from where?
Could You use Pivot-table?
I made a sample ... You could use filter it many ways.
Hint: it would be more clear if Your writing and sample text are same ... eg Location ... if guess, it could be same as Tariff Loc or how?
 

Attachments

  • PCD Data.xlsx
    19.5 KB · Views: 8
Back
Top