+ Reply to Thread
Results 1 to 11 of 11

calculate serial No and Business type result in C:C excel formula..

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    584

    calculate serial No and Business type result in C:C excel formula..

    Dear Experts

    I want calculate serial No A:A and business type: B:B

    Result IN C:C

    if serial No A:A In A1234 and Business Type B:B Business Call is first call I want result A1234 - 0
    if repeats same Business call Result also A1234 - 0.........................
    if serial No A:A In A1234 and Business Type B:B Partner's Call is first call I want result A1234 - 3
    if serial No A:A In A1234 and Business Type B:B Partner's Call is first call I want result A1234 - 3
    if serial No A:A In A1234 and Business Type B:B Partner's Call is first call I want result A1234 - 3

    Please Find the attachment!!! You may understand..
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: calculate serial No and Business type result in C:C excel formula..

    I dont think I understand very well.

    whats changing the last number of the calculated value correct?
    the change is triggered by:
    the call type? and call order of the type?

    Thanks

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: calculate serial No and Business type result in C:C excel formula..

    I used helpcells to get to the result.

    e2=if(B2=$E$1,A2&" - "&L2,A2&" - "&"0")

    e1 = PATNER'S CALL


    See the attached file.

    Please reply.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    584

    Re: calculate serial No and Business type result in C:C excel formula..

    dude my requirement is
    I WANT CALCULATE FIRST SERIA NO A1234 AGAINST BUSINESS CALL SHOULD BE "0" THEN WANT TO CALCULATE HOW MANY PATNER'S CALL FOR SAME SERIAL NO,

    E.G IF SERIAL NO IS A1234 THEN BUSINESS CALL IS I WANT RESULT SHOULD BE "0" BECAUSE I WANT TRACK BUSINSS CALL AS FIRST CALL
    IF AGAIN SERIAL NO IS A123 THEN PARTNER'S CALL IS I WANT CALCULATE HOW MANY TIMES PARTNER'S CALL

    A1234 BUSINESS CALL RESULT A1234-0
    A1234 PARTNER'S CALL RESULT A1234-4
    A1234 PARTNER'S CALL RESULT A1234-4
    A1234 PARTNER'S CALL RESULT A1234-4
    A1234 PARTNER'S CALL RESULT A1234-4

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: calculate serial No and Business type result in C:C excel formula..

    1) Please don't respond in UPPER; it looks like screaming.

    2) Did you look at my added file?

    If so (and I hope you did) where do you find a diferance with your desired result?

    Please reply.

  6. #6
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: calculate serial No and Business type result in C:C excel formula..

    =a2&" - " & if(b2="business call",0,countifs(a:a,a2,b:b,"patner's call"))

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: calculate serial No and Business type result in C:C excel formula..

    @breadwinner,

    You were on the forum, when i posted #4.

    Please respond on that topic.

    I noticed you don't answer (also not in other topic's) if the solution is usefull for you.

    Please reply on this one.

  8. #8
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    584

    Re: calculate serial No and Business type result in C:C excel formula..

    Thanks Mr. fredlo2010 Good to see the result with your master piece of formula Works Perfectly!!! Keep helping me

  9. #9
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: calculate serial No and Business type result in C:C excel formula..

    You are welcome. My formula implements all the clarifications I needed in my first post.

    Thanks oeldere for your help and insights

    Fan Page

  10. #10
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: calculate serial No and Business type result in C:C excel formula..

    @fredlo2010

    Thanks for the reply.

    Glad I could help you.

    @breadwinner

    How come you don't feel the need to reply, even if your asked for it?

  11. #11
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: calculate serial No and Business type result in C:C excel formula..

    oeldere there is no need to be man. I am sure breadwinner will behave better next time. and Thanks for standing up for me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to calculate SLA by excluding non-business hours, weekends and holidays
    By kokilak@hcl.com in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-04-2016, 11:42 PM
  2. excel formula to calculate days result achieved or not achieved
    By breadwinner in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-22-2013, 08:39 AM
  3. Unable to calculate business days and hours (Excel Noob).
    By Sabm11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2012, 12:55 PM
  4. No. of unique per month by type of business
    By mintribe in forum Excel General
    Replies: 4
    Last Post: 12-14-2011, 03:00 PM
  5. calculate business days with excel
    By hooba in forum Excel General
    Replies: 2
    Last Post: 11-26-2007, 05:26 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1