Filter out specific values from same column name in two different files

[Chirag_Gandhi07]

Hi All,

I have two data files with one common column. I sort both of those columns in ascending order. In one file, I need to take the last value for that column and basically match that with the value from the other file. I then need to take the values below the value that matched and filter them out. So below is an example:

Column A (File 1)                   Column A (File 2)

Abc123                                     Abc123

Def350                                     Def350

Def350                                     Def350

234Bhg                                    Jkl456

                                                DHY532 

                                                234Bhg

                                                Jiu782

                                                Dea451

So what I would like to happen is that it looks at the last value from column A (File 1) which is 234Bhg and compares that to Column A (File 2) and filters out all the values below 234Bhg from Column A (File 2). In this case, the values that would be filtered out would be Jiu782 and Dea451.

Any and all help is greatly appreciated. Thanks!

[Simha · Accepted solution]

Hi,

Here's a solution to your problem. Don't forget to accept the solution, if it works for you 🙂

Regards

Simha

[Chirag_Gandhi07]

Thank you! @Simha 

[Simha]

You are welcome @Chirag_Gandhi07. Glad I could be of help.