CAPF 5s and CAPF9s Report

From CAPipedia
Revision as of 15:31, 31 March 2020 by DavidDlugiewicz (talk | contribs) (Created page with "== "CAPF 5s and CAPF9s Given by Check Pilots in the Past Year" Heading text == === To use the Report for sorting or filtering === # Download the excel "CAPF 5s and CAPF 9...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

== "CAPF 5s and CAPF9s Given by Check Pilots in the Past Year" Heading text ==

To use the Report for sorting or filtering

  1. Download the excel "CAPF 5s and CAPF 91s given in the past year"
  2. Delete the first 4 lines (CAP Logo and title) TOP Line should be the headers Full Name Task Completed Aircraft Check Pilot
  3. Select Entire Speadsheet
  4. Click on Home > Merge & Center > Unmerge Cells
  5. Click on Home > Find & Select > Go to Special > Select Blanks
  6. Go to the first blank Cell that is highlighted
  7. Type = and the press Up Arrow (the cell should fill with the cell letter and Number
  8. Press CTRL + Enter
  9. Delete Column C and H (will have a #REF in them)
  10. Delete Bad rows at the bottom

The report is then sortable

Retrieved from "https://capipedia.cap.gov/index.php?title=CAPF_5s_and_CAPF9s_Report&oldid=355"