Highline Excel 2013 Class Video 26

Excel Compare Two Lists Formula: Item In List? Item Not In List?

DESCRIPTION

Topics in this video:
1. Is Item In List 2 also in List 1? Use MATCH and ISNUMBER. Comparing a prospective customer sales phone list to the companies master customer list.
2. Sort Dialog Box to get records to top.
3. Is Item in List 2 NOT in List 1? Use MATCH and ISNA. Comparing Library database list of books to the list of items found in inventory count.
4. IF, ISNA and MATCH functions to show “Missing” when book from library shelves is missing.

Compare two columns, Compare 2 columns, Compare 2 lists, compare two lists, compare two lists of items. Match two columns, Match 2 columns.

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 105 times – 21 MB




Be the first to comment

Leave a Reply