Row Formula

[AS]

Hi Experts,

Can you please help me in solving this. If in similar Company code, Emp Name is appearing 2 times so we need to choose only Fixed type row.

Company Code	Name	Type
101	Alex	Fixed
101	Alex	Variable
121	Nemo	Variable
120	Micheal	Variable
123	Act	Fixed
121	Nemo	Fixed

Output-

Company Code	Name	Type
101	Alex	Fixed
120	Micheal	Variable
123	Act	Fixed
121	Nemo	Fixed

[binuacs]

@AS