Reply to thread

Message: [QUOTE="Luke M, post: 3811337"] First, to create a list of unique Fleet numbers. First cell in column ( say, Z2) do a simple =A2 Next cell: =IF(COUNT(MATCH(A$2:A$100,Z$2:Z2,0))<COUNT(1/(A$2:A$100<>"")) INDEX(A$2:A$100,MATCH(0,(A$2:A$100<>"")-ISNA(MATCH(A$2:A$100,Z$1:Z1,0)),0)),"") and copy down as needed. Now, to get the data we want. To get Column B, put this in AA2 =OFFSET(B1,SUMPRODUCT(($A$2:$A$100=$Z2)*($C$2:$C$100=MAX(IF($A$2:$A$100=$Z2,$C$2:$C$100,0)))*ROW($A$2:$A$100))-1,0) Copy this down as needed. To get other columns, change the intial reference of "B1" to whichever column you want. [/QUOTE]