Auto Filters

I have turned the "Auto Filters" on in the three Excel files you are likely to be using. Most people should find them very helpful when searching for information.

You can turn them off if you do not want to use them:

In Microsoft Excel:
Click on "Data" - a drop down menu at top of screen.
Click on "Filter"
Click on "AutoFilter"

In Microsoft Excel Viewer:
Click on "View" - a drop down menu at top of screen.
Click on "AutoFilter"

At the top of each column heading is a "down arrow". If you click on this "down arrow" a summary of information contained in that column will appear. If you click on an individual item Excel will filter the file by that item. If you want to further refine the filter check the "Custom" setting.

You can do this for as many columns as you wish.

If you wish to look for entries about a particular unit go to the column heading "UnitDesc" and click the "down arrow" beside it, and then select the unit you are looking for.

If you wish to look for entries about a "Cause of Death" go to the column heading "Cause" and follow the previous procedure.

The difference between the "Mortality Files" with or without Units is that the "with units" file contains an entry for every unit a person served with.
The advantage of this approach is that a veteran whose death is reported by one unit will show up, when searched, against every unit he (or she) served with (in Vietnam only).
The disadvantage is that it will give an inflated value when searching for items such as cause of death. The "Without units" file is better used in that situation.

If you appear to not be getting any results check that the "Split" line is not hiding the results. Click on the "Split" line and move it up and it will disappear or disable it in the "Window" drop down menu.

The links below will get you to where you wanted to go.