Excel help

[Nadeem Ahmed Kh]

Suppose I have two numbers excel sheet, both are contain lot of data like numerical value or text or any other value and suppose some data, value or numerical value are common in both sheet, then what formula should be applied to find out the value or data which are not same in both sheet.

[syar]

Suppose I have two numbers excel sheet, both are contain lot of data like numerical value or text or any other value and suppose some data, value or numerical value are common in both sheet, then what formula should be applied to find out the value or data which are not same in both sheet.

Walikum Salam

Go through the following links may be you can adopt. otherwise share your sample data. Or search on forum you will find different solution.

http://www.itdunya.com/t139775/
http://www.itdunya.com/t139352/
http://www.itdunya.com/t161756/

regards,

[Nadeem Ahmed Kh]

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 .......

[syar]

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

=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

=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

[Nadeem Ahmed Kh]

As per your sheet
Agar Column A to C sa match krna ha tu try

=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

=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

G^8.............Thanks Sir........thanks.