If your member names contain unicode of msf.gg color codes then the roster.csv will have weird names in the output.

Use this page to map these names around.

In all the code on this wiki the names must match the values in roster.csv, so you will often map the human readable version to the roster.csv version.

Create the Name Lookup Sheet

Create a new sheet named Name Lookup

Column A contains the Human Readable names

In cells A1 to A24 type in the human readable names.

If most of them are already correct then just paste the values from column B and change the ones that need fixing.

These names won't be sorted, as the data is sorted on Column B.

Column B contains the roster.csv names

In cell B1 enter

=Sort(Unique(Roster!A2:A))

This will create a unique list of all the names in your roster and sort them.

Using the Name Lookup

=ArrayFormula({ VLOOKUP(A31:A54, 'Name Lookup'!$A:$B, 2, FALSE) })

This array formula will automatically fill in all 24 members of your alliance with their roster.csv name instead of the human readable version.

The names are in A31:A54, when you paste this in change the reference to where the human readable names are located on your new sheet.

The lookup is done against 'Name Lookup'!$A:$B

The value returns in Column 2 (the roster.csv version of the name).

The VLOOKUP is marked as not sorted so that failed matches will return #N/A