Cell Formula Issue: Most common number not working as expected in row 8301

·

looking for some help with a cell formula. The formula is attempting to look through all the phone numbers in a row and return values that occur more 2 or more times. It works for some but not for others. The cell with the formula is "Most common number" and an example of it not working is row 8301. The output should be the number that is in both (N) Contact Phone and 1 Wireless.

6 comments

Sean R.
·
·
https://app.clay.com/workspaces/12952/tables/t_fEcyJxVid690/views/gv_cIsgurg58YBv
Clay Team
APP
·
·
Hey there Sean sorry for the delay, taking a look.
Sean R.
·
·
Np, thank you!
Clay Team
APP
·
·
Sorry for the delay still taking a look.
:thumbsup_all:1
Clay Team
APP
·
·
So I think I found the issue, some cells seemed to have an extra whitespace in their value, which can through the formula off guard. I made a new formula for you next to the original, you can look at the text and see what it was that I did to get the output..
Sean R.
·
·
Ahhh that makes sense, great catch.