coba dengan array formula
=A13&"-"&TEXT(MAX(RIGHT($G$3:$G$24,5)*(LEFT($G$3:$G$24,2)=A13))+COUNTIF($A$3:A13,A13),"0")
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On
Behalf Of A. Zainal H.
Sent: Monday, June 24, 2013 7:38 PM
To: belajar-excel@yahoogroups.com
Subje
Coba array formula :
=A3&"-"&TEXT(MAX((LEFT($G$3:$G$24,2)=A3)*MID($G$3:$G$24,4,9))+COUNTIF(A$3:A3,A3),"0")
Wassalam,
Kid.
2013/6/24 A. Zainal H.
> **
>
>
> السَّلاَمُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
> Dear all Be-Exceller
>
> Trims All atas bantuannya
> hehehe ternyata cukup sim
2 matches
Mail list logo