Q
QPQ
Hello Everyone. I have an excel sorting problem that I could use some
help with. Here goes:
I have a list of phone number ids that are associated with a customer
number. I also have a phone number that is associated with the phone
number id. What I am trying to do is sort the phone numbers to match
the customer numbers. This would be done by sorting the phone number
ids to match the sequence that they are attached to the customer id.
Example
Phone ID Customer ID Phone ID
Phone Number
0183 1
0001 (555) 555-5555
0001 2
0002 (555) 555-5555
3452 3
0003 (555) 555-5555
0007 4
0004 (555) 555-5555
2348 5
0005 (555) 555-5555
How Do I sort The Phone ID that is in numeric sequence to match the
phone ID that is arranged in Customer Id Sequence? IE The Phone
Number is Sorted to properly match the Customer ID?
I am new to this. Sorry if I left anything out. Any assistance would
be greatly appreciated.
Regards,
Henry
help with. Here goes:
I have a list of phone number ids that are associated with a customer
number. I also have a phone number that is associated with the phone
number id. What I am trying to do is sort the phone numbers to match
the customer numbers. This would be done by sorting the phone number
ids to match the sequence that they are attached to the customer id.
Example
Phone ID Customer ID Phone ID
Phone Number
0183 1
0001 (555) 555-5555
0001 2
0002 (555) 555-5555
3452 3
0003 (555) 555-5555
0007 4
0004 (555) 555-5555
2348 5
0005 (555) 555-5555
How Do I sort The Phone ID that is in numeric sequence to match the
phone ID that is arranged in Customer Id Sequence? IE The Phone
Number is Sorted to properly match the Customer ID?
I am new to this. Sorry if I left anything out. Any assistance would
be greatly appreciated.
Regards,
Henry