Excel - Look for Duplicates and Put in Order based on another Column 2

[LZido]

I need a formula in Column B that will look for duplicate INCIDENTNUMBER from column A and then put them in order based on Response times in Column C. Example: there are three incident numbers "150013" in column A. In column B, I need to see the order based from lowest response time to highest response time from column C. If there is no duplicate then just want a "1" in column B


INCIDENTNUMBER Unit in order Response
1500001 [tt][tt][tt][tt][/tt][/tt][/tt][/tt][tt][/tt] 1 0:17:46
1500003 [tt][/tt] 1 0:03:16
1500004 1 0:06:32
1500005 1 0:04:38
1500006 1 0:05:02
1500007 1 0:08:21
1500008 1 0:06:11
1500009 1 0:06:38
1500011 2 0:08:07
1500011 1 0:06:33
1500013 3 0:04:11
1500013 2 0:04:09
1500013 1 0:03:06
1500014 1 0:08:47
1500015 1 0:03:50
1500016 1 0:06:14
1500019 1 0:09:06
1500020 1 0:06:01

 

[SkipVought]

hi,

I'd SORT the table as desired and use a simple formula

If [Previous incidentno]<>[incidentno] then 1 else [prev Unit in order]+1

 

[LZido]

Thanks - that did the trick.

 

[SkipVought]

Glad you got a solution.

But I see a deeper problem. The data listed are only valid for one day. What about the data for yesterday, tomorrow, the day after that etc? You need DATE & TIME!

 

[Andrzejek]

LZido,

It is customary on TT to give a star to people who helped you. This star also marks the helpful post so others can benefit from it.
Click on “Great Post? Star It” link.


Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[LZido]

Will do! Good to know about the star. Good to know I can get help!