AA is short for Armed Forces of the Americas - all branches of the military forces of the United States (Army, Air Force, Coast Guard, Marine Corps and Navy). APO is short for Army Post Office, which is part of the Military Postal System; it serves land-based military personnel (typically Army and Air Force). FPO is short for Fleet Post Office and serves water-based soldiers (typically the Navy, Marine Corps and Coast Guard).
Count distinct values in Excel (unique and 1st duplicate occurrences) To get a count of distinct values in a list, use the following formula: =SUM(1/COUNTIF(range, range)) Remember, it's an array formula, and therefore you should press the Ctrl + Shift + Enter shortcut instead of the usual Enter keystroke.
Find Duplicates. This example teaches you how to find duplicates (or triplicates) in Excel. Go here to remove duplicates. 1. Select the range A1:C10. 2. On the Home tab, click Conditional Formatting, Highlight Cells Rules, Duplicate Values... 3. Select a formatting style and click OK. Result.Excel highlights the duplicate names.Note: select Unique from the first drop-down list to highlight the unique names.. Select the range A1:C10. 2. On the Home tab, click Conditional Formatting, Highlight Cells Rules, Duplicate Values... 3. Select a formatting style and click OK. Result. Excel highlights the duplicate names. Note: select Unique from the first drop-down list to highlight the unique names.