<div>
This isn't the complete answer, but it might get you started:<br />
<br />
<a href="http://www.automationanywhere.com/solutions/ST/T32.htm" rel="ugc">http://www.automationanywhere.com/solutions/ST/T32.htm</a>
</div>


This isn't the complete answer, but it might get you started:

http://www.automationanywhere.com/solutions/ST/T32.htm [http://www.automationanywhere.com/solutions/ST/T32.htm]

<div>
not sure where to go with that one?
</div>


<div>
You're welcome and I'm glad I was able to help.<br />
<br />
Marty - MVP 2009 to 2013
</div>


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

Marty - MVP 2009 to 2013

<div>
<div class="content wysiwyg-content">
I have the latest version of Excel as shown here <a href="http://screencast.com/t/TmhIc9kz" rel="ugc">http://screencast.com/t/TmhIc9kz</a>. &nbsp;If a duplicate company name occurs in column A, then the row that contains data in the least number of columns should be removed where the row that contains data in the most number of columns should remain. &nbsp;Assistance is &nbsp;greatly appreciated.
</div>
</div>


I have the latest version of Excel as shown here http://screencast.com/t/TmhIc9kz.  If a duplicate company name occurs in column A, then the row that contains data in the least number of columns should be removed where the row that contains data in the most number of columns should remain.  Assistance is  greatly appreciated.

Duplicate removal rule extension needed

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