I have data in column B(PART NUMBER), C(Info) and additional data in column G(MPNs). I need to filter column B (C respectively) to show rows matching data in column G.
How to filter PART NUMBER column to show only the rows matching the values in MPNs column - see attached example.xlsx.
Actually I am not sure if "Filter" is the right way, because I did not find any option in this function.
Bookmarks