Clay Icon

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.

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    Hey there Sean sorry for the delay, taking a look.

  • Avatar of Sean R.
    Sean R.
    ยท
    ยท

    Np, thank you!

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    Sorry for the delay still taking a look.

  • Avatar of Clay T.
    Clay T.
    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..

  • Avatar of Sean R.
    Sean R.
    ยท
    ยท

    Ahhh that makes sense, great catch.