ExcelBanter - comparing two columns revisited

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - comparing two columns revisited (https://www.excelbanter.com/excel-worksheet-functions/229520-comparing-two-columns-revisited.html)

JoeM[_3_]

comparing two columns revisited

Now I need to find a way to show data in 3 columns. The first column has id
#s and the second is a sub category of that. The third column is a shorter
list of duplicates of the second. I need to show which are duplicates and
what Id they are under.

Glenn

comparing two columns revisited

JoeM wrote:
Now I need to find a way to show data in 3 columns. The first column has id
#s and the second is a sub category of that. The third column is a shorter
list of duplicates of the second. I need to show which are duplicates and
what Id they are under.

Maybe a brief example would make this clearer?

All times are GMT +1. The time now is 04:58 AM.