Help with data sorting.

[Seyk1701]

My data is such that I have quite a few duplicate work orders, depending on how many visits have been per workorder. Also, it's possible one workorder had more than one engineer, so for the second engineer the status is typically recorded as "as per lead engineer".

My data is arranged like this...

Work Order No	Status	Total Visits
00010021	Incomplete
00010021	As Per Lead Engineer	2
00010188	As Per Lead Engineer
00010188	Complete	2
1000852979	Incomplete
1000852979	As Per Lead Engineer
1000852979	Complete	3

What I require is work orders to be arranged by status, so the work orders that have been completed, the "Complete" status WO needs to be listed first and then "Incomplete" and "As Per Lead Engineer". For work orders not yet completed, "Incomplete" needs to appear before "As per....". In my total visits column, I have a formula that counts all visits and totals on the last work order. Once again, I need this to be aligned with (where necessary) "completed", otherwise "incomplete".

Thanks

 

[dreid1011]

Here is a neat tool you can use to make a custom sort list.

 

[Seyk1701]

Here is a neat tool you can use to make a custom sort list.

Thanks, but unfortunately this isn't going to work in my case. My data is already sorted by duplicates, I need to see every instances. I'm looking for my data to be sorted like this:

Work Order No	Status	Total Visits
00010021	Incomplete	2
00010021	As Per Lead Engineer
1000852979	Complete	3
1000852979	Incomplete
1000852979	As Per Lead Engineer

 

[MARK858]

Thanks, but unfortunately this isn't going to work in my case.

Can you explain more clearly why it won't work.
With the sort set up as below and all 3 columns selected (with the 3rd column as values not formulas)

I get the below, can you let us know what is incorrect with the first 2 columns in the result below

Book1
	A	B	C
1	Work Order No	Status	Total Visits
2	00010021	Incomplete
3	00010021	As Per Lead Engineer	2
4	00010188	Complete	2
5	00010188	As Per Lead Engineer
6	1000852979	Complete	3
7	1000852979	Incomplete
8	1000852979	As Per Lead Engineer
Sheet1

 

[MARK858]

With a formula in the 3rd column I get

Book1
	A	B	C
1	Work Order No	Status	Total Visits
2	00010021	Incomplete	2
3	00010021	As Per Lead Engineer
4	00010188	Complete	2
5	00010188	As Per Lead Engineer
6	1000852979	Complete	3
7	1000852979	Incomplete
8	1000852979	As Per Lead Engineer
Sheet1

Cell Formulas
Range	Formula
C2:C8	C2	=IF(A2=A1,"",COUNTIF($A$2:$A$8,A2))

 

[Seyk1701]

With a formula in the 3rd column I get

Book1
	A	B	C
1	Work Order No	Status	Total Visits
2	00010021	Incomplete	2
3	00010021	As Per Lead Engineer
4	00010188	Complete	2
5	00010188	As Per Lead Engineer
6	1000852979	Complete	3
7	1000852979	Incomplete
8	1000852979	As Per Lead Engineer
Sheet1

Cell Formulas
Range	Formula
C2:C8	C2	=IF(A2=A1,"",COUNTIF($A$2:$A$8,A2))

My apologies, I was having a moment. Yes, it works absolutely.

 

[MARK858]

Glad you got it "sorted", happy we could help and welcome to the forum