sprakash1704
New Member
- Joined
- Mar 5, 2015
- Messages
- 28
Dear Experts!
Relatively I am new to this forum, when I say relatively, I have been using this forum just to search and get answers for all my excel related queries for almost 6 years now and haven't posted anything or even registered. Thanks to all the experts who have helped me so for!
The question I have here is based on the table provided below. The data and headers in the column is fluctuating as this is a pivot, I will need to refer the pivot and will be extracting the required data based on "Emp ID". Need Help in doing this by formula, as I am not coding expert and I love working with formulas.
Experts I require this quite urgently, so please help!!!!!
<colgroup><col><col span="9"></colgroup><tbody>
</tbody>
Kind Regards,
Prakash
Relatively I am new to this forum, when I say relatively, I have been using this forum just to search and get answers for all my excel related queries for almost 6 years now and haven't posted anything or even registered. Thanks to all the experts who have helped me so for!
The question I have here is based on the table provided below. The data and headers in the column is fluctuating as this is a pivot, I will need to refer the pivot and will be extracting the required data based on "Emp ID". Need Help in doing this by formula, as I am not coding expert and I love working with formulas.
Experts I require this quite urgently, so please help!!!!!
Emp ID | Jan | Feb | Mar | Jul | Aug | Sep | Oct | Nov | Dec |
22705 | 4888.47 | 195.3 | 5170.18 | 5635.55 | 5263.22 | 6038.22 | 4787.53 | 5081.35 | |
31799 | 5487.5 | 1388.69 | 1314.11 | 1182.74 | 1311.87 | 712.1 | 1807.24 | ||
39974 | 4063.28 | 6090.46 | 4595.35 | 7673.24 | 7280.15 | 3753.64 | 4459.22 | ||
57683 | 4212.66 | 159.42 | 4363.84 | 4372.54 | 4251.25 | 5323.53 | 4084.27 | 4063.28 | |
57794 | 5569.82 | 5751.9 | 5696.69 | 6038.89 | 4378.91 | 4467.81 | |||
61546 | 40.19 | 4733.94 | 4664.96 | 3729.11 | 5026.33 | 4609.51 | 5487.5 | ||
61547 | 2435.05 | 5086.47 | 5191.55 | 4810.99 | 3932.63 | 4715.96 | 4212.66 | ||
66751 | 4467.81 | 5979.45 | 5475.14 | 2220.97 | 5752.75 | 3794.56 | 4888.47 | ||
71060 | 5512.42 | 2014.37 | 1786.68 | 2434.34 | 2175.93 | 1375.38 | |||
77571 | 50.21 | 4799.73 | 7239.91 | 6204.31 | 5383.25 | 4883.97 | 5300.31 | ||
90537 | 126.44 | 4909.14 | 4511.42 | 5032.8 | 5749.05 | 2075.37 | 5066.75 |
<colgroup><col><col span="9"></colgroup><tbody>
</tbody>
Kind Regards,
Prakash