excel

Sort By : featured | recent | views | rating | oldest | comments | alphabetically
imgtutorial

Merging two Excel files using VLOOKUP function

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.
Views 26034 | Rating 41 | Comments 17| Date Jan 13, 2008
imgtutorial

How to enter data into Excel in an ascending order with automatic numeric number increment?

Let's say we want to enter data such as Part1, Part2, Part3, Part4, Part5, up to several hundreds (e.g. Part200) with numeric number increment. The following will be what you want to enter: Part1 Part2 Part3 Part4 . . . Part200
Views 5036 | Rating 18 | Comments 7| Date Jan 11, 2008