That's a pretty vague description which gives us nothing to move forward with.
The macro I provided in post #5 of the thread I linked to is not that complicated - at least it isn't very long. It has a few assumptions listed above it and it has two lines in it that are clearly marked as needing modification.
1. Are the 4 assumptions I listed applicable to your situation (at least numbers 3 & 4 as 1 and 2 are dealt with in the code)? If not, please give details.
2. Did you modify the 2 lines near the top to match your sheet name and column number and then try the code? If so, and it did not produce the correct results for you, please explain in what way it did not.