Multi Row formula or Summarize tool

[tep_49]

Hi Everyone,

This is my sample data.
Have to group by by rollno. and then for the set of unique roll no if any of the values in prime contains " pass" have to return "Pass" for all the associated records
else return "No"
basically if atleast one pass is there for a roll no. then return pass for all the records containing that roll no. or else return "No"
Please help
appreciate it

[flying008 · Accepted solution]

Hi, @tep_49 

FYI.

Input					Output
Rollno	Name	Marks	Prime		Rollno	Name	Marks	Prime	Concat_Prime
12	Ajay	85	pass		12	Ajay	85	pass	Pass
12	Ajay	23	fail		12	Ajay	23	fail	Pass
15	Ram	90	fail		15	Ram	90	fail	No
41	Sham	74	pass		41	Sham	74	pass	Pass
41	Sham	12	fail		41	Sham	12	fail	Pass
47	Karan	78	fail		47	Karan	78	fail	No
75	Sunil	85	pass		75	Sunil	85	pass	Pass

[tep_49]

Appreciate your help.

It worked .