ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   find multiple occurances of a value and match to values in another (https://www.excelbanter.com/excel-discussion-misc-queries/105395-find-multiple-occurances-value-match-values-another.html)

carl43m

find multiple occurances of a value and match to values in another
 
I am trying to find several occurances of a text value in one column and then
based on the rows that the occurances were found to find names in the same
rows from another column. None of the rows are sorted. The text in the
first column can be anywhere int column.

Any hep is appreciated.

Carl

E.Q.

find multiple occurances of a value and match to values in another
 
Hi Carl,
Can you use the Data- Filter- Autofilter for this and select desired text
value?

"carl43m" wrote:

I am trying to find several occurances of a text value in one column and then
based on the rows that the occurances were found to find names in the same
rows from another column. None of the rows are sorted. The text in the
first column can be anywhere int column.

Any hep is appreciated.

Carl



All times are GMT +1. The time now is 03:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com