solusi formula alternatif (formula array)
{=INDEX($C2:$G2;MATCH(SMALL(COUNTIF($C2:$G2;"<"&$C2:$G2);COLUMN(A1));COUNTIF($C2:$G2;"<"&$C2:$G2);0))}
copy ke kanan dan ke bawahlihat attachment wassalam Ghozi Alkatiri ________________________________ Dari: Mohammed Asseggaf <[email protected]> Kepada: [email protected] Dikirim: Minggu, 16 September 2012 19:48 Judul: [belajar-excel] cara sort per row Halo semua,…. lagi bingung nih mau nge sort row ,.. tapi ada beberapa row,… Bagaimana yah caranya
ghozi 16092012 sort per row.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
