Sorting by 3 columns
Hello again,
I have gotten my spreadsheet up and running with the macro's and it
works great, when there are big changes a little tweak here and there
and everything still works great. I couldn't be more thankful to all of
those who have helped.
But I have another question.
Now I need to sort by three columns. For example:
A B C D
Test 1 2 3
Test2 1 2 3
Test3 8 9 0
Now I want to compile a list from column D if they have the same value
in B and C and there are two of the same value in D. So because B and C
of Test and Test2 are the same I want to see if there are two of the
same value in D. If there is I want to have a Spreadsheet with B C and
D.
Now this probably isn't very clear, please ask questions to help me
clarify this I can't think of a better way at the moment.
Thanks for all the help again.
|