Sorting Revision Labels in Excel
Hi,
Am Fri, 13 Dec 2013 17:32:15 +0000 schrieb Hockeynow70:
We have revision controlled documents and I need to sort large lists to
determine, for example, the latest Revision in the list. To do this, I
need Excel to sort by Part Number, then by the Revision in the order
they are shown below. The Revision value is located in a cell adjacent
to the Part Number.
try in C2:
=IFERROR(IF(CODE(LEFT(B2))57,CODE(LOWER(LEFT(B2)) )+1000000+IF(LEN(B2)=1,0,MID(B2,2,5)/1000),IF(CODE(RIGHT(B2,1))
64,LEFT(B2,LEN(B2)-1)*1000+CODE(RIGHT(LOWER(B2),1)),B2*1000)),B2)
and copy down.
Then sort by Part Number and helper column
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|