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”
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…?