Count the rows and give the desired output

[sneha_bhiwagade1]

Hi Team,

I hope you all are doing well!!

I have a below table where for one subject when we have the same roll numbers in multiple rows than output A else output B

Please find the below table

roll no	subject	output
1	english	A
2	english	B
1	english	A
3	hindi	B
4	hindi	B

Many Thanks in advance

[alexnajm]

This table seems to follow the rule provided - can you provide more information?

[binu_acs]

@sneha_bhiwagade1 one way of doing this

[sneha_bhiwagade1]

Hi Team,

My input table is 

1	english
2	english
1	english

output table is

roll no	subject	output
1	english	A
2	english	B
1	english	A

So here basically i have to check for subject = english do i have the same roll number in multiple rows if yes then i need the output as A else B

Many thanks in advance :)

[alexnajm]

@binu_acs 's solution works then