A B C D
Bob Rm1 x 0
Jack Rm1 x 0
Dean Rm2 n 0
John Rm2 n 0
Barb Rm3 x 0

I only want to select the data in Columns C and D where the Rm# in each of the rows of data = Rm1

Example:
Premise: If I wanted to select the data from Column C and D with Column B = Rm1
Solution: I would select Columns C and D in rows 1 and 2.

I'm going to replace the x in Column C with "n/a" and the 0 in Column D with "j/k"