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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Formula based Cell Content Return Unique Consecutive Duplicate Values 8
Return Unique Duplicate Numeric Values across Single Row 7
Count & Sum Consecutive (2x) appearance of Specific Numeric Values 2
Count & Sum Consecutive (2x) appearance of Specific Numeric Values 7
Match Criteria & Return Sequential Count 8
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row 5
Transpose unique values in one column/mult. rows into a single row 1
(Part 2) - Retrieve Numeric Label for Max Value by Specific Day & Month 4

Back
Top