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.
How to Set the Default Cell Value in Excel 2007. Microsoft Excel allows the entry, storage and organization of a large amount of data to be user-friendly. However, when entering data, you may not have explicit values available for all columns in your spreadsheet. It can be useful to have these columns default to a certain value. For instance, you may wish the priority of a task to default to Medium or a country in an address to default to United States of America.