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.
Count how often a value occurs. Applies To: Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 More... Suppose you want to find out how many times particular text or a number value occurs in a range of cells. If a range, such as A2:D20, contains the number values 5, 6, 7, and 6, the number 6 occurs two times.