I have a set of Data in sheet "BList", with both S/No and Date code combined in one cell - a "/" in between them.
I want to check and compare them with sheet "AList" - S/No and Date Code in 2 separate cells.
and to show the result with Status not equal to "CAR" but Serial Number & Date Code found in BList.
Sample file is attached. Thanks.
I want to check and compare them with sheet "AList" - S/No and Date Code in 2 separate cells.
and to show the result with Status not equal to "CAR" but Serial Number & Date Code found in BList.
Sample file is attached. Thanks.