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!

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

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

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.