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

I have given a sales data month wise, need to calculate month wise new customer repeat percentage. The details and dataset have been there in excel.

M

mdshadab

New Member
Kindly suggest any formula or idea to find new customers. Tried using a combination of countifs formula but not able to derive the results.
 

Attachments

  • Assignment_Repeat Analysis_BA role.xlsx
    125.4 KB · Views: 5
Last edited by a moderator:

mdshadab​

As You've read

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
How to get the Best Results at Chandoo.org
  • When drafting a question, try and lay out the question in a clear and concise way.
  • Try and tell the readers what is the situation, what have you tried and what do you want to achieve.
  • Don't leave out information more info is better
  • For the best/fastest results, Upload a Sample File ( = Attach file )
 
Yes its a type of assignment only just wanted to know how i can extract M1, M2 values. I have tried various countifs and nested it with other formulas but was unable to derive the objectives. So if any suggestions for finding out as it is becoming complex for excel to derive the results. Not asking for complete finalisation of the assignment, anyway thank you for the going through my thread.
 
Clear.
then, try to include a logical function in your formula. What's a new customer? Maybe, it's when he did his first order?
 
You must log in or register to reply here.
Back
Top