none
How to add duplicate value ( based on store & Month ) with multipule critaria RRS feed

  • Question

  • Hi all

    I want to create a logic but not get desired result. actually I am working on a list in which A customer have unique Membership no. and customer visits in our different store or same store sometimes perches twice a day. I get customer list end of the month from our store. I want calculate their discount but problem is that I need to calculate store wise if member visit in different store. All it I have to do manually every month. I hope it make some sense to understand.

    Membership No Member Name Store Name Month Members's City Name Total Amt in Electronics Product F&B / Other Total Amt Points in EP Points in F & B Total Point
    4242000239 Anand Senuguru  Meluha Aug-14 Mumbai 60000 8925 68925 2400 334.6875 2734.6875
    4242001285 S Muthukumar  Meluha Aug-14 Mumbai 14000 1935 15935 560 72.5625 632.5625
    4242001589 Abdulrahman Yusyri Bin  Meluha Aug-14 Mumbai 21000 3895 24895 840 146.0625 986.0625
    4242001710 Hjalmar Peetoom  Meluha Aug-14 Mumbai 151500 5375.5 156875.5 6060 201.58125 6261.58125
    4242001716 Cristobal Baradas  Meluha Aug-14 Mumbai 160500 27549 188049 6420 1033.0875 7453.0875

    Wednesday, October 8, 2014 11:27 AM

Answers

All replies

  • Excel 2010 with free PowerPivot and Power Query Add-In
    Compatible with Office 2013 Pro Plus. Or request 2013 file.
    http://www.mediafire.com/view/90b7wjtzm71pdzh/10_08_14.xlsx

    • Marked as answer by Arun Sandhu Thursday, October 9, 2014 4:51 AM
    Thursday, October 9, 2014 12:13 AM
  • Thanks Herbert

    Your answer is suitable for my data but I don't have knowledge of Visual basic so that it's look a little bit complicated for me to apply I would be heartily thankful if you can suggest me easy way to do that and any video or any website link because I want to use it with better understanding.

    Thanks Again !

    Thursday, October 9, 2014 4:50 AM
  • If you have Office 2013 Pro Plus, read these books:
    "Microsoft Excel 2013, Building Data Models with PowerPivot"
    by Alberto Ferrari and Marco Russo
    "Power Query for Power BI and Excel"
    by Chris Webb
    A very difficult, months long project.

    Thursday, October 9, 2014 1:17 PM
  • Yes I have MS Office 2013 Pro Plus.

    Thanks for your guidance. I will surly read these.

    Friday, October 10, 2014 4:24 AM