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

The firm definition

Y

yaelcohen

Member
Hello Expert,

Thanks for any help!

The question is relates to firm definition C or D in the attached file.

I need to define the firm as follows:
If firm has class A in any year - it will get A in this year
If firm has class B&D during the years - it will bet calss B
If firm has class B&C during the years - it will bet calss B
Please help me to add D to my formula in column F

Thanks a lot!
 

Attachments

  • Question27.xlsb
    9.4 KB · Views: 2
Thanks for your fast answer, I attached again the file and also add a clarify
as: If firm has class B,C,D during the years - it will stay in the same class

Thanks for your help!
 

Attachments

  • Question27.xlsb
    9.7 KB · Views: 3
Dear,
below formula will work but i have one question
If you see YelloW Firm Details, It has got A,B from 2008 till 2013. So the result should be A as per your condition, check

=IF(COUNTIFS($B$4:$B$50,B4,$D$4:$D$50,"A")>0,"A",IF(COUNTIFS($B$4:$B$50,B4,$D$4:$D$50,("B"))>0,"B",E4))
Click to expand...
 
It almost perfect AND thanks for the help!

it the firm-year is A it should be A for the same firm year.
As for Yellow firm, it should be A for these observations the has A and B for these observations that has B

THANKS A LOT!
 
Yes Ashhu, I checked your formula in thread # 6 and my answer for this is:

It almost perfect AND thanks for the help!

it the firm-year is A it should be A for the same firm year.
As for Yellow firm, it should be A for these observations the has A and B for these observations that has B (attached the revised file)

THANKS A LOT!
 

Attachments

  • Question27.xlsb
    10 KB · Views: 3
Dear Ashhu,

Thanks for your help.

I attached again my file and apologize if it was not clear. As I wrote, it almost perfect. it the firm-year is A it should be A for the same firm year.
As for Yellow firm, it should be A for these observations the has A and B for these observations that has B (attached the revised file)

Sorry for the misunderstanding
 

Attachments

  • Question27.xlsb
    10 KB · Views: 5
You must log in or register to reply here.
Back
Top