Deleting Multiple Occurrences of a Value

Houstonwolf

Board Regular
Joined
Jul 28, 2006
Messages
154
Hello. I am trying to truncate an existing report to make it more usable for my department's needs. You can see that the attached report contains multiple entries for the Trl# in Col F. I only need the trailer listed once (to another worksheet would be fine or I could delete all repeated instances of the Trl# in F providing any instance remined in the worksheet once and only once).

Any ideas as to how this can be done?
DV02 Report.xls
CDEFGHIJ
1SCACTrl#Part#HPWO#SchdShipDateActualShipDateSchdDelDateApptDate
2SWFT500961Q5933A#ABA100039299209/01/0609/01/0609/06/0609/06/06
3SWFT500961Q7822A#ABA100039301109/01/0609/01/0609/06/0609/06/06
4SWFT500961Q5985A#100039325509/01/0609/01/0609/06/0609/06/06
5SWFT500961Q6500A#ABA100039326009/01/0609/01/0609/06/0609/06/06
6SWFT500961Q6503A#ABA100039326509/01/0609/01/0609/06/0609/06/06
7SWFT500961Q5987A#ABA100039326609/01/0609/01/0609/06/0609/06/06
8SWFT500961Q5927A#ABA100039330709/01/0609/01/0609/06/0609/06/06
9SWFT500961Q6455A#ABA100039335109/01/0609/01/0609/06/0609/06/06
10GRSF4176Q3714A#ABA100039293909/01/0609/01/0609/04/0609/04/06
11GRSF4176Q3715A#ABA100039294009/01/0609/01/0609/04/0609/04/06
12GRSF2102Q3944A#ABA100039330109/01/0609/01/0609/06/0609/06/06
13CTRQ33271Q3714A#ABA100039293909/01/0609/01/0609/04/0609/04/06
14CTRQ33271Q3944A#ABA100039330109/01/0609/01/0609/04/0609/04/06
15CTRQ13379Q5927A#ABA100039298409/01/0609/01/0609/04/0609/04/06
16CTRQ13379Q6500A#ABA100039326009/01/0609/01/0609/04/0609/04/06
17CTRQ13379Q5987A#ABA100039326609/01/0609/01/0609/04/0609/04/06
18CTRQ13379Q6455A#ABA100039335109/01/0609/01/0609/04/0609/04/06
19CEPA4776Q6455A#ABA1000392948-109/01/0609/01/0609/04/0609/04/06
20CEPA4776Q5927A#ABA100039298409/01/0609/01/0609/04/0609/04/06
SEP 06
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Houstonwolf

Board Regular
Joined
Jul 28, 2006
Messages
154
Sorry. It's the Trl# in Col D. (I deleted some columns for better visibility.)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,381
Messages
5,547,613
Members
410,803
Latest member
lsweeney
Top