Return Unique Consecutive Duplicate Values across Single Row

  • Thread starter Thread starter Sam via OfficeKB.com
  • Start date Start date
Definitely look at Domenic's response.
Where I misinterpreted your criteria, built a formula that listed
same-column multiples, then fiddled with it to list consecutive dupes....he
paid attention. His formula does what you want without all the side trips.

***********
Regards,
Ron

XL2002, WinXP
 
Hi Ron,

Thank you for all your help.

Will see Domenic's post, thanks.

Cheers,
Sam
 
Hi Domenic,

Thank you very much for your assistance. Does the job great. Brilliant!

Cheers,
Sam
Assuming that A2:H8 contains the data, try the following...


...confirmed with CONTROL+SHIFT+ENTER

leave empty
Click to expand...
 
Back
Top