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.
Default Values in Cells. Hi In Excel i need a particular cell to always have a default value. Say Cell B1 always needs to be 22. If any values are given in Cell A1, then B1 should diaplay that value. And if anyone deletes the value in Cell B1 still by default it should show 22 as the value. Is it possible.Faisal.i In Excel i need a particular cell to always have a default value. Say Cell B1 always needs to be 22. If any values are given in Cell A1, then B1 should diaplay that value.