Am I able to find duplicated and missing data on one sheet

Hi

I have 2 sets of data in columns A-E , In column A it will say 1 or 2 thus notifying it set 1 or 2 of data and then the data.

What im trying to do is look all the way down the sheet comparing data in each row in columns A-E and if data  in column "A" but not in row marked  2 I need it marked in column F of  row concerned  "MISSING FROM ROW 2"

I then need it to run all the way through the worksheet the other way round where as if in column A there in no data in row marked  1  but there is data marked 2 in need the row marked "MISSING FROM ROW 1"

Finally I need it to compare all data that starts with no2 in column A and if duplicated  I need one of the  entries marked "DUPLICATE"

If same data in rows marked in column A 1 and 2 then I dont need anything doing.