Sort of format Question
 

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

If those are real dates and times you need to extract the dates into a help
column
with a formula

=INT(A2)

copy down and copy and paste special as values in place, then another to
find the 2 places ashland and booth ranch, insert a new help column and use

=OR(ISNUMBER(SEARCH({"Ashland";"Booth Ranch"},D2)))

copy down

apply datafilterautofilter, filter on TRUE to get all the ashland/booth
ranch, then
select the whole filtered range, press F5 and click special and select
visible cell, copy and paste into a new sheet,

then sort by plate number and date (from the help column) , that should give
you all that fullfill those conditions together, now you can copy them to
another place, remove all the help columns and do the calculations


Regards,

Peo Sjoblom

"o5prey" wrote:


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