EIDs as Dates

Here's a list of end users we have whose EID defaults to date format, if you have an Excel sheet set up that way:

This list is incomplete (mostly faculty) at the moment (2018-05-08), will be completed with staff in a month or two

Helpful Excel Formulas

Pull info from one column into separate columns (e.g. a list of computers attached to one email Excel sheet with this formula

{=IFERROR(INDEX(OKtag,SMALL(IF(OKemail=$K2,ROW(OKtag)-MIN(ROW(OKtag))+1),COLUMNS($K$2:K2))),"")}

Pull all instances of a computer associated to one email (to create final mail merge list) Excel sheet with this formula

{=IFERROR(INDEX(master!E$2:E$1200,MATCH(1,($D2=master!$D$2:$D$1200)*(master!E$2:E$1200<>""),0)),"")}