I like to compare two columns and need to write the output 1 or 0 (if the both are same 0,different 0).
Example:Let us say i have column A with some Name(alphanumeric) and column B with some Name (alphanumeric).The name in the A and B might be same or different.The same Name in Column A will in Column B in the different CellB.I like to compare both of them and pick out by assing the values 1 or 0.Pl let the solution.Thanks in Advance.
Example:Let us say i have column A with some Name(alphanumeric) and column B with some Name (alphanumeric).The name in the A and B might be same or different.The same Name in Column A will in Column B in the different CellB.I like to compare both of them and pick out by assing the values 1 or 0.Pl let the solution.Thanks in Advance.