Merging two Excel files using VLOOKUP function is very powerful and convenient for Data Analysis when manual matching of two files is very time consuming because of size of data.
Let’s look at one example situation here.
Excel File One has two columns. Column one is for the student IDs and the other column is for dates ACT test were taken.
Excel File Two also has two columns. One column is for the student IDs and the other column is for dates SAT
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar