View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kris Kris is offline
external usenet poster
 
Posts: 34
Default 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.