Simple Extract cell contents per input conditions

Hello Friends

The cells values Column A to E is being populated by formulas.

Now the `NR' will be constant and remaining will be variable i.e., will change.

1) If all 5 cells from A to E in row is `NR' then plot NR by formula in light yellow cell.
2) If another one variable with or without `NR' then plot the variable.
3) If with or without `NR' if more than one variable then plot `Stop'.

thanks in advance.

G1=IFERROR(IF(COUNTIF(A1:E1,LOOKUP(2,1/(A1:E1<>"NR"),A1:E1))+COUNTIF(A1:E1,"NR")=COUNTA(A1:E1),LOOKUP(2,1/(A1:E1<>"NR"),A1:E1),"Stop"),"NR")
Try this and copy towards down

Hello Siva

Thank you, This helps me to extract the required attribute.

thanks again.

thanks & thanks