2 different sheets Excel

[heyheyhey]

Hello again,

If I have 2 diff sheets, sheet A contains some of the same information
located on Sheet B, ex., my name is on both sheets, is there a way I can
Identify that the same names are on both sheets without counting them
individually?

 

[PCLIVE]

One way:
Names in column C on both sheets.

=IF(COUNTIF(Sheet2!C:C,C1)>0,"On Both Sheets!","One Sheet Only")

HTH,
Paul