Hai Semprul Ki,
Asumsi :
1. data di sheet1 cell A2
2. format date data DMY dengan delimiter dash '-'
Array formula :
=DATE(MATCH(TRIM(MID(SUBSTITUTE(A2,"-",REPT("
",99)),2*99,99)),ROMAN(ROW($1900:$3999)),0)+1899,MATCH(TRIM(MID(SUBSTITUTE(A2,"-",REPT("
",99)),99,99)),ROMAN(ROW($1:$12)),0),MATCH(TRIM(LEFT(SUBSTITUTE(A2,"-",REPT("
",99)),99)),ROMAN(ROW($1:$31)),0))
Jika dibuat nama range :
>> *myData *sebagai proses text to columns dari data dengan formula pada
refers to :
=TRIM(MID(SUBSTITUTE(Sheet1!$A2,"-",REPT("
",99)),(ROW(Sheet1!$1:$3)-1)*99+1,99))
>> *myRoman *sebagai daftar angka romawi di Excel (dari 1 sampai 3999),
dengan formula pada refers to :
=ROMAN(ROW(Sheet1!$1:$3999))
Maka formula konversi date roman ke date arabic numerals menjadi :
=DATE(MATCH(INDEX(*myData*,3),*myRoman*,0),MATCH(INDEX(*myData*,2),*myRoman*
,0),MATCH(INDEX(*myData*,1),*myRoman*,0))
Regards,
Kid.
2011/11/29 Ki Semprul <kisemp...@rocketmail.com>
> VI-IX-MMXI
> XVIII-VII-MMXI
> XXIII-XI-MMX
> VI-V-MMXI
> XIX-II-MMX
> XVIII-IX-MMX
>
re-roman2arabic_numerals.xls
Description: MS-Excel spreadsheet
