Advanced Sorting With Excel

  • Thread starter Thread starter justforthis1
  • Start date Start date
J

justforthis1

ok ive been trying to make excel do this, but im stumped...

basically i have a sheet that has

group tag description part #
#1 1 misc ABCD123ABC
#1 2 misc DEF12XYZ
#1 3 misc 123ABC

#2 4 misc LMNOP123ABC
#2 5 misc XYZ12ABC
#2 6 misc 345ABC

#3 7 misc ABCD123ABC
#3 8 misc DEF12XYZ
#3 9 misc 123ABC

#4 10 misc HJKL123ABC
#4 11 misc XYZ12XYZ
#4 12 misc 789ABC

#5 13 misc LMNOP123ABC
#5 14 misc XYZ12ABC
#5 15 misc 345ABC

i want each group to behave like a single row instead of 3
i want to be able to sort by part # and have all the groups that have
the same part numbers with each other...

for instance...

group tag description part #
#1 1 misc ABCD123ABC
#1 2 misc DEF12XYZ
#1 3 misc 123ABC

#3 7 misc ABCD123ABC
#3 8 misc DEF12XYZ
#3 9 misc 123ABC

#2 4 misc LMNOP123ABC
#2 5 misc XYZ12ABC
#2 6 misc 345ABC

#5 13 misc LMNOP123ABC
#5 14 misc XYZ12ABC
#5 15 misc 345ABC

#4 10 misc HJKL123ABC
#4 11 misc XYZ12XYZ
#4 12 misc 789ABC

if anyone can help me with this that would be great...

thanks
 
Assuming your headings are in row 1 and the data is in columns A - D, enter
the following in E2 and copy down through all rows of data (including the
blank rows):

=IF(OR(A2=A1,ISBLANK(A2)),E1,D2&A2)

If you want to eliminate the blank rows, use:

=IF(A2=A1,E1,D2&A2)

Then, sort data by column E.

Hope this helps,

Hutch
 
Back
Top