jan-17

Hi all, How do I calculate vested shares, in a particular month, based on the vesting date? For example, I am trying to solve for Cells I2 and N2, the correct answer will be 25,000, however I don't know how to set up the formula to calculate based on the date in row 1. D2:G2 are the vesting...

<tbody> Table 1 Metric1 (Unique) Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 A B C D E F Table 2 Metric1 Month Metric2 A Jan-17 166 A Apr-17...

I got data as mentioned below in excel. All the activities are split in two different periods. For each such period I have to create a shape and place it according to its date and duration along the same row. e.g. in the below mentioned table for activity A, I will create two rectangular shapes...

Hi All, Please can you assist. I am trying to pull a number of rows and columns together based on criteria within a INDEX,MATCH formula. <tbody> A B C D E Code Name Jan-17 Feb-17 Mar-17 0 John 10 20 30 1 John 20 30 40 2 John 30 40 50 0 Ben 5 10 15 1...

HI, Need help again. In Cell A1, I have data validation list - Jan 17, Feb 17, Mar 17 & so on In B1, I have list of members like A, B, C, D In Sheet2, I have raw data contains A Jan-17 B Jan-17 A Feb-17 C Feb-17 A Feb-17 B Mar-17 What if I change month in data validation then it should...