Manually comparing two lists in Excel to find matching entries or differences can be a tedious and error-prone task. Fortunately, Excel offers several built-in features and functions that make this process efficient and accurate. Instead of wasting valuable time on manual comparisons, you can leverage Excel’s capabilities to quickly identify matches and discrepancies between two lists. This guide will explore three straightforward methods to Excel Compare Two Lists For Matches, utilizing Conditional Formatting, the IF function, and the versatile MATCH function.
Key Takeaways:
- Discover how to use Excel’s Conditional Formatting to visually highlight row differences between two lists.
- Learn to apply the IF function to compare lists row-by-row and display “Match” or “Not a Match” results.
- Master the MATCH function to effectively determine if values from one list exist in another, identifying matches and mismatches.
To follow along and practice these techniques, download our sample Excel workbook:
Download Excel Workbook: Compare Two Lists for Matches
Method 1: Highlight Row Differences Using Conditional Formatting
Conditional formatting in Excel provides a quick visual way to pinpoint differences between two lists on a row-by-row basis. This method is particularly useful for identifying variations in corresponding rows across two columns of data.
Here’s how to highlight row differences:
STEP 1: Begin by selecting both lists you wish to compare. In our example, these are located in Column A and Column B.
STEP 2: Navigate to the Home tab on the Excel ribbon. In the Styles group, click on Conditional Formatting. Hover over New Rule… and select Use a formula to determine which cells to format.
STEP 3: In the “New Formatting Rule” dialog box, enter the following formula in the “Format values where this formula is true” field:
=$A1<>$B1
STEP 4: Click the Format… button to specify how you want the differences to be highlighted. For instance, you can choose to fill the cells with a color or change the font style. Select your desired formatting and click OK in both the “Format Cells” and “New Formatting Rule” dialog boxes.
Excel will now automatically highlight any cells where the values in the corresponding rows of Column A and Column B are different.
STEP 5 (Optional): To further emphasize the differences, you can change the font color of the highlighted cells. Go to Home > Font Color and choose a color like red to make the discrepancies stand out even more.
This conditional formatting technique provides an immediate visual representation of row differences, making it easy to quickly identify discrepancies between your two lists.
Method 2: Compare Rows Using the IF Function
The IF function in Excel allows you to perform logical comparisons between two lists on a row-by-row basis. It returns a specified value if the condition is true and another value if the condition is false. This is perfect for comparing corresponding entries in two lists and indicating whether they “Match” or “Not a Match”.
Let’s walk through the steps to excel compare two lists for matches using the IF function:
STEP 1: Select an empty column next to your lists where you want to display the comparison results. In the first cell of this column (e.g., cell C1), enter the IF function. The basic structure is =IF(, which starts the formula.
STEP 2: Define the logical test. For row-by-row comparison, you need to check if the value in the current row of the first list is equal to the value in the same row of the second list. For example, if your lists are in columns A and B, and you are starting in row 1, the logical test would be A1=B1. Your formula now looks like: =IF(A1=B1,
STEP 3: Specify the “value_if_true”. This is the text or value you want Excel to display if the logical test is TRUE (i.e., the values match). For example, enter "Match" to display the word “Match” when the values are identical. The formula becomes: =IF(A1=B1,"Match",
STEP 4: Specify the “value_if_false”. This is the text or value to display if the logical test is FALSE (i.e., the values do not match). For example, enter "Not a Match" to indicate a mismatch. The completed formula will be: =IF(A1=B1,"Match","Not a Match")
STEP 5: Apply this formula to the rest of the rows in your lists. Click and drag the fill handle (the small square at the bottom-right corner of the cell containing the formula) down to apply the formula to all corresponding rows.
Now, the column where you entered the IF function will display “Match” for rows where the values in the two lists are the same and “Not a Match” where they differ.
Method 3: Compare Lists Using the MATCH Function
The MATCH function is a powerful tool for excel compare two lists for matches by identifying if and where values from one list exist in another. Unlike the IF function, which compares row by row, MATCH checks if a specific “lookup value” is present within a “lookup array” (a range of cells).
Understanding the MATCH Function
The MATCH function searches for a specified item in a range of cells and returns the position of that item within the range.
Formula Breakdown:
=MATCH(lookup_value, lookup_array, [match_type])
- lookup_value: The value you want to search for (from your first list).
- lookup_array: The range of cells where you want to search (your second list).
- [match_type]: (Optional) Specifies the type of match. Use
0for an exact match, which is typically needed when comparing lists for identical entries.
This method is particularly useful when you need to determine if items in List 1 are present in List 2, regardless of their row order.
Here’s how to use the MATCH function to compare two lists:
STEP 1: Choose an empty column next to your List 1 to display the results. In the first cell of this column, enter the MATCH function: =MATCH(
STEP 2: Define the lookup_value. This is the value from List 1 that you want to check for in List 2. Select the first cell in List 1. For example, if List 1 starts in cell A1, the lookup_value is A1. Your formula now looks like: =MATCH(A1,
STEP 3: Define the lookup_array. This is List 2, the range of cells where you want to search for the lookup_value. Select the entire range of List 2. For example, if List 2 is in column B from row 1 to 10, select B1:B10. Crucially, press F4 to make this an absolute reference ($B$1:$B$10). This ensures that the lookup array remains fixed when you copy the formula down. The formula now looks like: =MATCH(A1,$B$1:$B$10,
STEP 4: Set the match_type to 0 for an exact match. Complete the formula: =MATCH(A1,$B$1:$B$10,0)
STEP 5: Apply the formula to the rest of the items in List 1 by dragging the fill handle down.
The MATCH function will return the row number where a match is found in List 2. If a value from List 1 is not found in List 2, the function will return #N/A.
The numerical results indicate the position (row number) of the matched item in List 2. #N/A signifies that the corresponding item from List 1 is not present in List 2. You can then filter your results to easily isolate matches or mismatches.
Practical Scenarios for List Comparison in Excel
Finding Exact Matches Across Spreadsheets
Imagine you manage inventory across multiple Excel sheets. Using the MATCH function, you can quickly check if product codes from a new shipment sheet exist in your master inventory list. This ensures you avoid duplicate entries and accurately update stock levels.
Identifying Discrepancies in Customer Lists
Sales and marketing teams often work with extensive customer lists. Comparing lists from different sources (e.g., CRM export vs. marketing campaign list) using MATCH can highlight missing customer records or identify data entry errors, ensuring data consistency across platforms.
Tips and Tricks for Optimizing Your List Comparison
Case-Insensitive List Comparisons
By default, Excel’s MATCH function is not case-sensitive. If you need to perform a case-sensitive comparison, you can combine MATCH with the EXACT function. The formula would become more complex, potentially involving array formulas, but it allows for precise, case-sensitive matching when necessary.
Error Handling for Cleaner Results
The #N/A error returned by MATCH when no match is found is informative, but you might want to display something more user-friendly, like “Not Found”. You can use the IFERROR function to handle #N/A errors and replace them with custom text. For example: =IFERROR(MATCH(A1,$B$1:$B$10,0),"Not Found")
Optimizing Performance with Large Lists
When working with very large lists, formula calculations can slow down Excel. For improved performance, especially with MATCH function, ensure your lookup arrays are limited to the necessary range and avoid volatile functions where possible. For extremely large datasets, consider using Excel’s Power Query for more efficient data manipulation and comparison.
FAQ: Frequently Asked Questions about Comparing Lists in Excel
Can I compare more than two lists at once?
While these methods primarily focus on comparing two lists, you can extend them to compare multiple lists. For example, you could use nested IF statements or more complex formulas combining MATCH and other functions to compare values across three or more columns. Power Query is also an excellent tool for merging and comparing multiple datasets in Excel.
Is there a way to find duplicate values within a single list?
Yes, Excel has a built-in feature to find duplicates within a single list using Conditional Formatting. Go to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values…. This will highlight any duplicate entries within your selected list.
Can I use wildcards with the MATCH function for partial matches?
Yes, the MATCH function supports wildcard characters for partial matches. You can use an asterisk () to match any sequence of characters or a question mark (?) to match any single character. For example, `”text*”` would find any cell containing “text”. Be cautious when using wildcards, as they can sometimes lead to unintended matches if your data is not consistently formatted.
What are the limitations of using formulas for list comparison?
While formulas like IF and MATCH are powerful, they can become complex and harder to manage for very intricate comparison tasks. For advanced data analysis and complex list comparisons, especially with large datasets or multiple criteria, Power Query or even VBA scripting might offer more robust and scalable solutions.
By mastering these three methods – Conditional Formatting, IF function, and MATCH function – you can efficiently excel compare two lists for matches and differences, saving time and improving data accuracy in your Excel workflows. Experiment with these techniques using the provided sample workbook and adapt them to your specific data comparison needs.
If you found this Excel tutorial helpful, please share it with others!
XFacebookLinkedInCopy[Email](/cdn-cgi/l/email-protection#3b54181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e081f4454181e09010e08
