A MIME stands for Multipurpose Internet Mail Extension. In
the context of internet or web applications the way of identifying files
according to their nature and format. While developing the web applications
specify content-type in the header part of HTTP – response. 

A MIME type is a
mechanism that can be informed to the client the variety of document
transmitted. Extensions of the files has plays a small role in the web. 

General form of MIME is type/subtype. it is the syntax for mime type

Below are few  MIME
types :

• Text/html - for Html files


• multipart/zip - for zip files


• Application/msword - for word documents


• image/jpeg - for JPEG image files

RFC defines messages have two parts one is header and a
body. These header and body represents in ASCII text format. The body of the message
is a simple text originally. RFC has decided how to send information in any
format means file or image or video. SO it was introduced MIME for sending
image type data or any other formatted data.

The message header is a series of <CRLF> terminated lines.
CRLF stands for carriage return line feed which are a pair of ASCII control
characters often used straight forward encoding of binary data into ASCII
character set.  This encoding is called
base64. In this approach every three bytes of data into 4 ascii
characters.  This is done by grouping the
binary data into 24-bit units and breaking each such unit into four 6-bits
pieces. Each 6-bit piece maps onto one of 64 valid ASCII characters;

A MIME message that consists of may be a regular text and
can be encoded using 7-bit ASCII.

In this article I am going to explain how to compare two excel
sheets data and highlight the missing data. This article is helpful in BPO
industry those who are dealt with finance and insurance sector.

Now a day’s everything automated in this comparison of two excel
sheets is taking too lengthy process and our eyes also gets strained so to
avoid that read the article and practice yourself with a sample data. If you
have any questions let me know.

Here I am using two functions 

VLOOKUP()

       MATCH()

Usage of VLOOKUP() function in excel:

Syntax of Vlookup function: 

First go to formulas tab and select Lookup & Reference
then click on VLOOKUP():

 Based on the syntax of the function pass the values like below:

Lookup Value - > What is the required value for searching.

Table Array -> Select the range where you want to find the given element.

Column Index -> Column number 

Range Lookup -> True or False

See the below practice excel sheet which contains the data:

 

By Using MATCH() Function:

Match Function Syntax:

 

 Go to formulas tab and select Lookup & Reference
then click on MATCH().

Fill the formula columns like below:

Look up value -> What the element you want to search, select that column.

Look up array -> Where you want to search the element select the range.

Match Type -> It is 0,1,-1  0 for exact match 1 or -1 greater than or less than

See the below practice excel sheet which contains the data:

 

PLEASE NOTE : in the above practice sheet NA means no match found.