"Tmaxx02" wrote in message
oups.com...
On Jun 8, 4:36 pm, "T. Valko" wrote:
This accounts for both ascending and descending values:

A B C D
3 4 1 34
4 3 1 43

=IF(ABS(A1-B1)=1,A1&B1&IF(ABS(B1-C1)=1,C1,""),IF(ABS(B1-C1)=1,B1&C1,""))

Biff

"Tmaxx02" wrote in message

ups.com...



I have a sheet with numbers in three columns.
That worked great. It also accounted for more than 2 numbers. Thanks
very much.

Terry

You're welcome. Thanks for the feedback!

Biff