Cari dan Tandai Data dengan VLOOKUP & CONDITIONAL FORMATING

  Рет қаралды 101

Ahsani_VidsT

Ahsani_VidsT

Күн бұрын

Cari dan Tandai Data dengan VLOOKUP & CONDITIONAL FORMATING
#trikexcel
#exceltips
#tutorielexcel
#belajarexcelpemula
#exceltutorial

Пікірлер: 2
@05_ameliaamrethacandra84
@05_ameliaamrethacandra84 Ай бұрын
terima kasih pak atas videonya, izin betanya jika data yang sudah dicari dibiarkan tetap berwarna merah ketika mencari data yang lainnya apakah bisa yaa
@ahsani_vidst4877
@ahsani_vidst4877 Ай бұрын
Sayang sekali tidak bisa, karena begitu kode acuan berubah maka formula dalam conditional formating juga akan diupdate dan mengabaikan kondisi sebelumnya.
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
Excel Level Up
Рет қаралды 2,5 МЛН
Excel VLOOKUP With Multiple Workbooks
12:14
Excel VLOOKUP With Multiple Workbooks
Maxwell Stringham
Рет қаралды 3,5 МЛН
Правильный подход к детям
00:18
Правильный подход к детям
Beatrise
Рет қаралды 11 МЛН
Cool Items!🥰 New Gadgets, Smart Appliances, Kitchen Tools Utensils, Home Cleaning, Beauty #shorts
00:40
Cool Items!🥰 New Gadgets, Smart Appliances, Kitchen Tools Utensils, Home Cleaning, Beauty #shorts
Cool Items Official
Рет қаралды 75 МЛН
To Brawl AND BEYOND!
00:51
To Brawl AND BEYOND!
Brawl Stars
Рет қаралды 17 МЛН
Quando eu quero Sushi (sem desperdiçar) 🍣
00:26
Quando eu quero Sushi (sem desperdiçar) 🍣
Los Wagners
Рет қаралды 15 МЛН
Belajar Google Sheets dari Nol Eps. 1 | Tutorial Google Spreadsheet Pemula - ignasiusryan
19:17
Belajar Google Sheets dari Nol Eps. 1 | Tutorial Google Spreadsheet Pemula - ignasiusryan
Ignasius Ryan
Рет қаралды 511 М.
Compare Two Lists Using the VLOOKUP Formula
12:49
Compare Two Lists Using the VLOOKUP Formula
Computergaga
Рет қаралды 2,9 МЛН
Membuat Search Box di Excel
17:27
Membuat Search Box di Excel
Clever Coworker
Рет қаралды 102
How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX
15:54
How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX
Tuts+ Computer Skills
Рет қаралды 5 МЛН
Belajar Excel dari Nol episode 1 | Tutorial Excel Pemula
10:04
Belajar Excel dari Nol episode 1 | Tutorial Excel Pemula
Ignasius Ryan
Рет қаралды 2,9 МЛН
Excel DGET Function Solves 2 of Your VLOOKUP Problems
11:18
Excel DGET Function Solves 2 of Your VLOOKUP Problems
Leila Gharani
Рет қаралды 878 М.
Trik VLOOKUP Level Mahir - Transfer Data Otomatis ke Banyak File Sesuai Nama Filenya
16:30
Trik VLOOKUP Level Mahir - Transfer Data Otomatis ke Banyak File Sesuai Nama Filenya
Ahsani_VidsT
Рет қаралды 322
Обучение EXCEL. УРОК 9: Умные таблицы EXCEL (динамический диапазон, DATA TABLES).
16:09
Обучение EXCEL. УРОК 9: Умные таблицы EXCEL (динамический диапазон, DATA TABLES).
Бархатов Виталий (EXCEL, VBA, PowerBI)
Рет қаралды 177 М.
How to Use VLOOKUP in Excel (free file included)
15:15
How to Use VLOOKUP in Excel (free file included)
Leila Gharani
Рет қаралды 399 М.
VLOOKUP in Excel | Tutorial for Beginners
32:09
VLOOKUP in Excel | Tutorial for Beginners
Kevin Stratvert
Рет қаралды 2,1 МЛН
Правильный подход к детям
00:18
Правильный подход к детям
Beatrise
Рет қаралды 11 МЛН