compare and remove

[avichava]

Hi 

I have a Master sheet it contains the data of the devices our project use and I have another file which have information about the Bad devices now I need to find bad devices using serial number from Master sheet and remove it from Master sheet..

[#2]

@avichava 

New column E on master sheet, assuming serial number is in column A on both master and bad devices sheet. E2

=XMATCH(A2,'bad devices'!A:A)

Fill down and use filter to find rows with numbers (=matching row) and delete them.