Im not sure really what direction I need to go here. I have a
spreadsheet that has.

Date/Time TZ Scale Location PlateST
04/20/2005 06:35 P PT 1507 Ashland POE 0000000OR
04/27/2005 05:19 P PT 1507 Ashland POE 0000000OR
04/21/2005 06:59 P PT 1507 Ashland POE 000000OR
04/26/2005 05:33 P PT 1507 Ashland POE 000000OR
04/15/2005 07:43 A PT 1507 Ashland POE 0000TX
04/16/2005 12:03 P PT 1008 Booth Ranch 00146RPWA

I want to sort or conditionally format of something so that I can
easily find entries that match each other based on 3 different
criteria

#1 They Need to have the Same Plate Number under PlateST.

#2 The need to have the same Date.

#3 Then they need to have Scale Location where one is Ashland and one
is Booth Ranch.

My problem is that I have thousands of these entries and I need to find
these so that I can run calculations for speed based on the entries that
match.


--
o5prey
------------------------------------------------------------------------
o5prey's Profile: http://www.excelforum.com/member.php...o&userid=23446
View this thread: http://www.excelforum.com/showthread...hreadid=376387