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

1. ## 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..

2. ## 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. ## 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.

4. ## 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 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. ## 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?

6. ## 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. ## Re: calculate serial No and Business type result in C:C excel formula..

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

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

8. ## 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. ## 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

@fredlo2010

11. ## 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.

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