Memahami penggunaan INDIRECT dan SUBSTITUTE di Excel
Teori tentang:1. Indirect klik di sini
2. Substitute klik di sini
Berikut ini penjelasan penggunaannya
Video 1:
Video 2: MEMBUAT MENU LIST dengan menggunakan formula
kombinasi INDIRECT dan SUBSTITUTE
langkah 1: buat "define name" pada range tabel
lihat video sebelum ini untuk cara membuat define name
langkah 2: isikan formula ini pada "data validation"
sel A15: =merk
sel B15: =INDIRECT(SUBSTITUTE(A15," ","_"))
sel C15: =INDIRECT(SUBSTITUTE(B15," ","_"))
Subscribe to:
Post Comments
(
Atom
)
If you're trying hard to lose kilograms then you certainly need to start using this totally brand new tailor-made keto plan.
ReplyDeleteTo create this keto diet, certified nutritionists, fitness trainers, and professional cooks have joined together to provide keto meal plans that are efficient, decent, price-efficient, and fun.
Since their first launch in 2019, 100's of clients have already completely transformed their body and health with the benefits a great keto plan can offer.
Speaking of benefits: in this link, you'll discover eight scientifically-tested ones given by the keto plan.
Did you realize there's a 12 word sentence you can say to your man... that will induce intense feelings of love and impulsive appeal to you deep inside his heart?
ReplyDeleteBecause deep inside these 12 words is a "secret signal" that triggers a man's impulse to love, treasure and look after you with his entire heart...
12 Words Will Fuel A Man's Desire Instinct
This impulse is so hardwired into a man's mind that it will drive him to work better than before to make your relationship the best part of both of your lives.
As a matter of fact, triggering this influential impulse is so mandatory to achieving the best ever relationship with your man that the second you send your man one of the "Secret Signals"...
...You'll immediately notice him open his heart and mind to you in such a way he never expressed before and he'll distinguish you as the one and only woman in the galaxy who has ever truly appealed to him.
As stated by Stanford Medical, It is indeed the ONLY reason this country's women get to live 10 years more and weigh on average 19 kilos less than we do.
ReplyDelete(And by the way, it has absolutely NOTHING to do with genetics or some secret-exercise and really, EVERYTHING about "how" they eat.)
BTW, What I said is "HOW", not "WHAT"...
TAP this link to see if this easy questionnaire can help you unlock your true weight loss possibility