View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam via OfficeKB.com Sam via OfficeKB.com is offline
external usenet poster
 
Posts: 247
Default Return Unique Consecutive Duplicate Values across Single Row

Hi Biff,

Thank you for your time and assistance.


T. Valko wrote:
Well, maybe not!


That formula works ok on the sample you posted but when I put it through the
"wringer" it chokes!


For example: (I guess this is possible?):


Yes, it is possible.

100...101
100...101
101...110
101...120
101...107


Biff


Cheers,
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200702/1