Hi,

trying to find a formula to extract a common 4 digit number from a list of 5 digit numbers

example:

12345
23456
22345
23457
41236
56789

2345 would be the common number for the above list. i know MODE can be used but only if the lists are all 4 digits.

thanks in advance.