|
VLOOKUP Example |
|
|
Written by Administrator
|
|
Thursday, 12 May 2011 13:59 |
VLOOKUP ExampleContoh VLOOKUP Sometimes we area confused how to do vlookup in our excel spreadsheet. Here is a simple example to do vlookup. Eg. You have a data table in the spreadsheet like this below, and you want to fill Column D (PartyName) from the table Party. The Party table you put it in the same worksheet on the Column H and column I. Kadang-kadang kita binggung bagaimana caranya membuat vlookup pada spreadsheet excel kita. Misalnya anda mempunyai data table seperti di bawah ini, dan anda ingin mengisi Column D dengan Nama Partai dari table Partai. Table partai anda letakan pada worksheet yang sama pada column H dan column I.
|
A |
B |
C |
D |
F |
G |
H |
I |
| 1 |
First |
Last |
Partycode |
PartyName |
|
|
Partycode |
PartyName |
| 2 |
Smith |
Fred |
A |
|
|
|
A |
Democratic |
| 3 |
Robbin |
William |
D |
|
|
|
B |
Republican |
| 4 |
Sentoso |
Bunyamin |
C |
|
|
|
C |
Decline To State |
| 5 |
Glen |
Sutono |
B |
|
|
|
D |
American Independent |
| 6 |
Maria |
Adelia |
E |
|
|
|
E |
Conservative |
So, the question how to to vlookup on the column D2 - D6 ? It is easy. All you need to do is to put this code "=VLOOKUP(H11;$H$3:$I$7;2;FALSE)" on the column D2 and then copy the column D2 to D3 - D6. Jadi pertanyaannya bagaimana kita membuat vlookup pada column D2 - D6 ? Caranya mudah, yang perlu anda lakukan adalah memasukkan syntax berikut ini "=VLOOKUP(H11;$H$3:$I$7;2;FALSE)" pada column D2 dan kemudian copykan ke column D3 - D6.
|
|
Last Updated on Thursday, 12 May 2011 16:28 |
|
Read more...
|
|
|
PDF Converter |
|
|
Written by Administrator
|
|
Wednesday, 19 January 2011 13:52 |
PDF Converter Professional 7.0  | PDF Converter Professional 7 is the smarter
PDF solution for business users. It provides everything you need to
convert, edit, share and create PDF files. It features 100%
industry-standard PDF--and the most accurate document conversion to
editable formats even from within Microsoft Office and Microsoft
Windows.
|
|
|
Last Updated on Wednesday, 19 January 2011 14:12 |
|
Read more...
|
|
Error Transition from COM context |
|
|
Written by Administrator
|
|
Thursday, 23 September 2010 05:39 |
Error Transition from COM context
When debugging .NET Application using Microsoft Visual
Studio, sometimes It appears an error like this below :
"The CLR has been unable to transition from COM
context 0x212c28 to COM context 0x212d98 for 60 seconds. The thread that owns
the destination context/apartment is most likely either doing a non pumping
wait or processing a very long running operation without pumping Windows
messages. This situation generally has a negative performance impact and may
even lead to the application becoming non responsive or memory usage
accumulating continually over time. To avoid this problem, all single threaded
apartment (STA) threads should use pumping wait primitives (such as
CoWaitForMultipleHandles) and routinely pump messages during long running
operations."
|
|
Last Updated on Thursday, 23 September 2010 06:00 |
|
Read more...
|
|
What is IP Address |
|
|
Written by Administrator
|
|
Wednesday, 01 September 2010 05:33 |
What Is An IP Address ?
Apa
itu Alamat IP ?
IP Address is stand for Internet Protocol Address.

According
to Wikipedia, an Internet Protocol address (IP address) is a
numerical label that is assigned to devices (printers, routers, modems, etc)
participating in a computer network that uses the Internet Protocol for
communication between its nodes. An IP address serves two principal functions:
host or network interface identification and location addressing. Its role has
been characterized as follows: "A name indicates what we seek. An
address indicates where it is. A route indicates how to get there." |
|
Last Updated on Wednesday, 03 November 2010 10:23 |
|
Read more...
|
|
How to open .ISO file ? |
|
|
Written by Administrator
|
|
Tuesday, 24 August 2010 11:18 |
How to open ISO File ?
Bagaimana caranya buka
file .iso ?  | An
ISO image is an image of files that can be burnt to a CD. If you’ve just
downloaded an ISO file, and be able to open the ISO file and edit its contents,
before burning it off on a CD, here’s a quick guide telling you how you can
open an ISO file. |
Sebuah
image ISO adalaha sebuah image files yang dapat di burn ke sebuah CD. Jika anda
baru saja mendownload sebuah file ISO,
dan dapat membuka file ISO dan mengedit isinya sebelum di burn k eke CD.
Ini ada caranya bagaimana anda dapat membuka sebuah file ISO. |
|
Last Updated on Thursday, 04 November 2010 05:46 |
|
Read more...
|
|
|
|
|
<< Start < Prev 1 2 3 4 5 6 7 8 Next > End >>
|
|
Page 1 of 8 |