Master Placement Records

Part 1: Master Placement Records Sheet Setup

Open Student's Master file

The current response tab is:

SIP

Google Sheets tab names must match exactly. If your tab name is different then make sure you use that name everywhere.

Step 1: Create a New Tab

In the master placement file, click the + button at the bottom-left.

Name the new tab:

CopyPlaced_Roll_List

This tab will contain only cleaned Roll Numbers. Company response sheets will import this roll list and highlight matching students.

Step 2: Paste Headers in Placed_Roll_List

Paste these headers in sheet: Placed_Roll_List, cell: A1:

CopyClean Roll No

Step 3: Paste this formula in cell A2

Copy=ARRAYFORMULA(IF('SIP'!B2:B="","",UPPER(TRIM('SIP'!B2:B))))

It's use is to standardize "Roll No." Example:

BM-025066 → BM-025066
bm-025066 → BM-025066
 BM-025066  → BM-025066