Hi Leo,

Sorry for not being clearer with my file. This is coming from my accounting program, it's noting a lot of additional data that I ended up removing so that we focus on this one column.

10/26/2018 $(22,752.68)
10/26/2018 $22,752.68
10/26/2018 $23,786.56
10/26/2018 $(3,975.30)
10/26/2018 $(23,786.56)

Column B already has all the numbers noted. Within the column though, there's a lot of entries like the below. Overall, I am trying find an easy way to match all the numbers (i.e., -$22,752.68 and $22,752.68, $23,786.56 and -$23,786.56), especially instances when there's 4 or more of the same matching numbers, and then possibly hide or filter them out of view.

My goal is to ignore these matching numbers, as they are zeroed out and then focus on the remaining items. Starting to read up on vlookup's and if this is a path that will work.

Approaching 3000+ entries, I'm hoping to find a way to streamline the process.

Best,

Eugene