View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tmaxx02 Tmaxx02 is offline
external usenet poster
 
Posts: 10
Default How can I do this?

I have a sheet with numbers in three columns.
I would like to have a formula or function to
look across the row and tell me if there is a
consecutive number. In other words:

A B C D
3 4 1 34

In column D, I'd like display the results 34 if
there are consecutive numbers.

Thanks in advance.