Hey… I am trying to insert a formula into an excel cell to determine whether there are duplicates in a list…

however, when I use variables to represent a first and second name, it is not successful (the formula does not read the names and the formula returns 0 when it should return 1).

The formula I am trying to write in a cell is… “=COUNTIFS(B:B,” + vStrFirstName.ToString + “,C:C,” + vStrLastName.ToString + ")"

See excel “NameCheck” and UiPath “NameCheck”

Namecheck.xaml (10.8 KB)

NameCheck.xlsx (8.5 KB)

The formula is successful when I use write cell “=COUNTIFS(B:B,”“Charlie”",C:C,"“Ellis”")"

See excel "NameCheck1"

Namecheck1.xaml (10.8 KB)

I think there is an issue with my first and second name variables, are you able to help please…?

Thanks