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.
It means that the row or column which comes after the dollar sign is anchored or absolute. When you copy Excel formulas, they will copy cells referred in that formula relative to the position where they are being copied to. Let's take a simple example. In Cell A1, I have the value 10. In Cell B1, I have the formula +A1. Cell B1 displays the value of 10 (since 10 appears in Cell A1).