<div>
Hi Mike,<br />
<br />
You say you have data in A-H but then say you want to put the results in H.<br />
<br />
You also say you want something listed if it is in 'all 6 columns'.<br />
<br />
Please can you clarify - maybe upload the data file?<br />
<br />
Thanks,<br />
<br />
Alan.
</div>


Hi Mike,

You say you have data in A-H but then say you want to put the results in H.

You also say you want something listed if it is in 'all 6 columns'.

Please can you clarify - maybe upload the data file?

Thanks,

Alan.

<div>
Sorry, Looking to populate column H with the common applications presents in each column A-G.
</div>


Sorry, Looking to populate column H with the common applications presents in each column A-G.

<div>
Can you prepare sample and show expected result?
</div>


Can you prepare sample and show expected result?

commondata.xlsm

<div>
Thanks Neil, I'm not familiar with how to run code in Excel. Could you provide some instructions on how to do that?
</div>


Thanks Neil, I'm not familiar with how to run code in Excel. Could you provide some instructions on how to do that?

<div>
Thanks Neil, that worked perfectly!
</div>


<div>
<div class="content wysiwyg-content">
I have an Excel table with columns A-H, rows 2-100. It is filled with text data (Application Names). I'm looking to populate column H with a list of common applications that are present in all 6 columns of the table.<br />
<br />
Duplicate value formatting doesn't work as it identifies anything that appears more than once, where as I'm looking only for what is present in all 6 columns.
</div>
</div>


I have an Excel table with columns A-H, rows 2-100. It is filled with text data (Application Names). I'm looking to populate column H with a list of common applications that are present in all 6 columns of the table.

Duplicate value formatting doesn't work as it identifies anything that appears more than once, where as I'm looking only for what is present in all 6 columns.

Finding common data in multiple columns

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

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

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