Posts by nou_pe_aici

    Hi all,

    do you have an idea of a formula that could help me to detect suspicious phone numbers in excel?

    I have a list of phone numbers each with 10 digits.

    I am trying to detect numbers that might be fake following the last 8 digits not to be:

    a) repetitive XXX XXXX

    b) consecutive (12345678) or the other way arround (87654321), at least 3 digits consecutive to be considered suspicious

    c) patern XYZ XYZ

    d) patern XY XY XY XY

    e) includes date (XX08202020), so is has the 2020 number in the string.

    any idea could help me :)

    thank you