Hi, I am a new user of excel to be truth. I am still learning how to use the macro function. hope that you guys can help me solve my problem that I am currently having.

So lets say I have a huge data and in that specific one column in the data will have few numbers that have the exact figures but they have different signs. and I only need numbers in that one column to match with each other and filter them together.

For example in that specific column:

100
23
56
-100
-23
-56

and I want it to be like this :

100
-100
23
-23
56
-56

How can I create a macro that can filter the numbers to match it together and bring along with the whole row as well?