Cara membuat dependent dropdown list

196 viewsFebruary 5, 2025excel

0

ajieechy487 55 January 9, 2025 0 Comments

Bagaimana cara membuat dependent dropdown list menggunakan Data Validation dan INDIRECT?

ahmadriz434 Answered question February 5, 2025

3 Answers

0

ahmadriz434 150 Posted February 5, 2025 0 Comments

Buat Data (kategori & subkategori).
Beri Nama Range (pakai Name Manager).
Dropdown 1: Data Validation → List → Pilih kategori.
Dropdown 2: Data Validation → List → =INDIRECT(A1).

ahmadriz434 Answered question February 5, 2025

You are viewing 1 out of 3 answers, click here to view all answers.