To find the names, codes or items that appear in both lists, test each value with COUNTIF, pull out the matches with FILTER, or highlight them with conditional formatting. Power Query’s inner join does the same for large tables. fx=FILTER(B3:B10,COUNTIF(D3:D9,B3:B10)) ProblemList or mark the values that are in both lists Functions usedCOUNTIF, FILTER, MATCH Works … Read more
Excel drops leading zeros from numbers, so 00125 becomes 125. To keep or add them for IDs, PIN codes or invoice numbers, use a number format, the TEXT function, REPT for text, or Power Query. Display onlyCustom format 00000 As textTEXT or REPT TypingStart with an apostrophe: ‘00125 1. Custom number format (keeps the number) … Read more
Following are 4 different methods that can be used to Jump to the First or Last sheet of an Excel Workbook. Method 1 Holding the Ctrl key, left-click on the small right arrow present in the bottom left corner of the workbook. You will land on the last worksheet of the active workbook. Similarly, to select the … Read more