Nadeem Ahmed Kh said:
Kindly find the attached sheet, there are in the sheet 02 nos of columns where some data/item are same in both column, then how can I calculate that which data or item is not second column, or which data/item are same how we calculate it, whats the formula should be applied. Sukriya .......
As per your sheet
Agar Column A to C sa match krna ha tu try
Code:
=MATCH(A1,$C$1:$C$19,0)
the formula will return #NA for No Duplicate and return Row Number of column where exact match found.
Ya aap apna formula thoda sa modify kr sakte hain like
Code:
=IF(ISNUMBER(MATCH(A1,$C$2:$C$190,0)),"the duplicate in row"&MATCH(A1,$C$2:$C$190,0),"No Duplicate")
Even you use conditional Formatting
please check the attached file.
regards
Bookmarks