# Compare two lists

### Compare 2 Data Lists in Excel using Conditional Formatting

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.

### Return Multiple Match Rows in Excel

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

### Compare two lists of equal length in Excel (row by row)

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

### Compare two lists of unequal length in Excel

Compare 2 lists contain TEXT duplicate values.

### Get Unique Distinct Elements in 2 Lists in Excel?

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.

### Use sparklines to show data trends in Excel

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.

### Track changes in Excel using Conditional Formatting

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.

### Highlight row differences/matches in Excel

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 in Excel

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.

### Which Elements from 2 Lists are Common?

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

### Compare 2 lists for common values in Excel

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

### Compare two tables in Excel (practice example)

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.