Compare two lists

Compare 2 column values. The comparison will be done row by row: if the value in the second column more than in the first, it will be highlighted in red if less green. Select cells will Conditional formatting.

Find the given strings in the table. Row consist of 2 columns, the values can be any.

Let this 2 list of Numeric values. Determine whether these 2 lists (comparison criterion: pairwise coincidence elements).

Compare 2 lists contain TEXT duplicate values.

Let this 2 the list of values. Define what are the elements of the first list is NOT contained in the second and what are the elements of the second list first are contained in the.

Trends in series of values (e.g., price fluctuations, sales) can be tracked in EXCEL with charts or conditional formatting. In this article we will look at sparklines (sparklines) which appeared in MS EXCEL 2010. Sparklines are located inside cells and are minigraphic that visualize the behavior of the data, maximum/ minimum values, and other singular points. 

performance is often monitored on a periodic basis, which generates appropriate reports. For example, sales volume for various groups of goods monthly to be entered into the table. For a quick analysis of the changes over the last month, you can use Conditional formatting.

Compare two tables having same structure (same number of rows and columns). The table will compare line by line: select the values from Table1 строки1 contained in Table2 row 1 and the values строки2 from Table1, contained in строке2 Table2, etc.

Compare two tables with almost same structure. Table different values in individual rows, some of the names of the rows found in one table, but another may be missing.

Let this 2 the list of values. We define the elements of the first list contains the second.

Let this 2 the list of values. Determine whether the intersection of these two lists (are there any items that are in both lists?)

In real life you often have to compare the lists created by different people, at different times, contain typos, extra spaces, data in the wrong format, etc. In this article, we will consider not only the comparison of lists, but also prepare them for the comparison.