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.
Number format in excel: Showing % value without multiplying with 100. up vote 5 down vote favorite. 3. When I set format of a cell as %, it automatically multiply the value with 100 & show the value. So 5.66 becomes 566 % . I want to apply % format on a column but want to keep the values same as before. I just want % sign to be shown along with the value.