29162547.xlsm

SAM2009

IT Professional

Albert Widjaja

COG Lead Engineer

Shaun Vermaak

<div>
Or use conditional formatting to highlight the dupes and then sort by color
</div>


Or use conditional formatting to highlight the dupes and then sort by color

<div>
You’re welcome and I’m glad I was able to help.<br />
<br />
If you expand the “Full Biography&quot; section of <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you’ll find links to some articles I’ve written that may interest you including a <mark>new one</mark> concerning <a href="https://www.experts-exchange.com/articles/33770/Are-you-aware-that-you-have-an-Experts-Exchange-Rank.html" rel="ugc">your Experts Exchange rank</a>.<br />
<br />
Marty - Microsoft MVP 2009 to 2017<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Experts Exchange Most Valuable Expert (MVE) 2015, 2017<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Experts Exchange Top Expert Visual Basic Classic 2012 to 2018<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Experts Exchange Top Expert VBA 2018<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Experts Exchange Distinguished Expert in Excel 2018
</div>


You’re welcome and I’m glad I was able to help.

If you expand the “Full Biography" section of my profile [https://www.experts-exchange.com/M_258447.html] you’ll find links to some articles I’ve written that may interest you including a new one concerning your Experts Exchange rank [https://www.experts-exchange.com/articles/33770/Are-you-aware-that-you-have-an-Experts-Exchange-Rank.html].

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange Most Valuable Expert (MVE) 2015, 2017
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2018
              Experts Exchange Top Expert VBA 2018
              Experts Exchange Distinguished Expert in Excel 2018

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
<br />
Is there way in Excel to find duplicate values? I don't want to delete but list duplicated value from a cloumn.
</div>
</div>


Hi,


Is there way in Excel to find duplicate values? I don't want to delete but list duplicated value from a cloumn.

Is there way in Excel to find duplicate values?

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.