Mencari & Menfilter Data di Sheets

function cariNama() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = sheet.getDataRange().getValues();

  const baris = data.find((r) => r[0] === 'Budi');
  if (baris) {
    Logger.log('Ditemukan: ' + baris.join(' | '));
  } else {
    Logger.log('Tidak ditemukan');
  }
}

function cariPosisi() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = sheet.getDataRange().getValues();
  const target = data.findIndex((r) => r[1] === 'Selesai');

  if (target >= 0) {
    const rowKe = target + 1; // +1 karena array mulai dari 0
    sheet.getRange(rowKe, 3).setValue('Sudah diproses');
  }
}

function filterBelumLunas() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = sheet.getDataRange().getValues().slice(1); // buang header

  const belumLunas = data.filter((r) => r[2] === 'Belum Lunas');
  Logger.log('Jumlah: ' + belumLunas.length);
}

function cariYangMengandung() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = sheet.getDataRange().getValues();

  const hasil = data.filter((r) => String(r[0]).includes('Admin'));
  Logger.log('Ketemu ' + hasil.length + ' baris');
}

function exportHasilFilter() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = sheet.getDataRange().getValues();
  const header = data[0];

  const hasil = data.filter((r, i) => i > 0 && r[2] === 'Lunas');

  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const baru = ss.insertSheet('Hasil Lunas');
  baru.getRange(1, 1, 1, header.length).setValues([header]);
  baru.getRange(2, 1, hasil.length, hasil[0].length).setValues(hasil);
}