Jalal Kasmani
Board Regular
- Joined
- Feb 14, 2015
- Messages
- 52
- Office Version
- 365
- Platform
- Windows
Hi All,
Below table has the Hiring requisition movement month on month.
Below are two columns which i update every month manually filtering the each month and recording what moved backward and what moved forward. I am very sure this can be done using a formula.
Comments column is a critical part. what i do is, i explain the variance count of column "G". I filter on column A on one hiring stage and see what had reduced from that stage(minus), than filter on column B and check what is added to that stage(plus). Please let me know if any doubts
Below table has the Hiring requisition movement month on month.
Book1.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Feb | Mar | ||
2 | Req to be raised | Req to be raised | ||
3 | Sourcing in progress | Sourcing in progress | ||
4 | Sourcing in progress | Offered | ||
5 | Sourcing in progress | Sourcing in progress | ||
6 | Sourcing in progress | #NA | ||
7 | Offerred | Sourcing in progress | ||
8 | Offerred | Offered | ||
9 | Pre-Offer | Joined | ||
10 | Pre-Offer | Pre-Offer | ||
11 | Pre-Offer | #NA | ||
12 | Req in Approval | Req to be raised | ||
13 | Offerred | Joined | ||
14 | Req to be raised | |||
15 | Req in Approval | |||
16 | Pre-Offer | |||
17 | Req to be raised | Req in Approval | ||
18 | Sourcing in progress | Pre-Offer | ||
19 | Sourcing in progress | Pre-Offer | ||
20 | Sourcing in progress | Pre-Offer | ||
Sheet1 |
Below are two columns which i update every month manually filtering the each month and recording what moved backward and what moved forward. I am very sure this can be done using a formula.
Book1.xlsx | |||||
---|---|---|---|---|---|
F | G | H | |||
21 | Summarry | Movement from Feb | Comments | ||
22 | Req to be raised | +1 | -1 moved to "Req in Approval", + 1 moved here from "Req in Approval", +1 New RJ raised. | ||
23 | Req in approval | +1 | + 1 moved to "Req to be raised", +1 moved here from "Req to be raised", + 1 New RJ raised | ||
24 | Sourcing in progress | -4 | -1 moved to offered, -3 moved to Pre Offer, -1 Req Cancelled, +1 moved here from "Offered" | ||
25 | Offered | -1 | -1 moved to "Sourcing in progress", -1 moved to "Joined", +1 moved here from "Sourcing in progress" | ||
Sheet1 |
Comments column is a critical part. what i do is, i explain the variance count of column "G". I filter on column A on one hiring stage and see what had reduced from that stage(minus), than filter on column B and check what is added to that stage(plus). Please let me know if any doubts