I have the employee name1 column "AC" and employee father's name in column "AD".
if the value ("name") is exists in AC and AD I need to put value 2 in the AE .
if only AC OR AD value exists the value should be 1 in COLUMN AE .
If no value exists in both columns the value in AE should be 0.
How do I achieve this using the excel formula ?