Loop through cells and return only unique values

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Loop through cells and return only unique values

FAQ

Thread Tools

Display Modes

10-11-2018, 11:34 AM

trevorc

Windows 7 32bit Loop through cells and return only unique values

Office 2013

Competent Performer

Join Date: Jan 2017

Posts: 173

Thanks, but after looking on the endless web I put together this.

Code:

   For Each rcell In Range("L4:L150")
        If rcell.Value Like "?*@?*.?*" Then
           next_cell_value = next_cell_value & "; " & rcell
           If InStr(next_cell_value, rcell) = 0 Then next_cell_value = next_cell_value & rcell & ";"
        End If
   Next rcell

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to group table by unique values in PowerPivot	rlf793	Excel	0	05-17-2017 05:23 PM
Count Duplicate Values without a specific Unique Value	Brittni	Excel	1	02-01-2017 06:22 PM
Count unique values that match 2 or more criteria	caeiro01	Excel	1	10-25-2015 02:34 AM
Combining Records of two sheets with Loop till Unique ID	abhilashv	Mail Merge	1	01-22-2014 04:02 AM
Display unique values and count the number of child items	vthomeschoolmom	Excel	2	07-25-2013 06:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:28 PM.