Good Day,
I am hoping there is someone that can help with a formula. The problem is the data is not captured constantly. So i have a name that gets captured in 3 different ways I need to find the value of this person for a specific month. Please if there is formula that I can use would be appreciated.
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
I am hoping there is someone that can help with a formula. The problem is the data is not captured constantly. So i have a name that gets captured in 3 different ways I need to find the value of this person for a specific month. Please if there is formula that I can use would be appreciated.
Sheet 1 | |||
A | B | C | |
Name | Sales | Month | |
John James Smith (John) | 20 | Oct-18 | |
John James Smith | 23 | Nov-18 | |
Smith John James | 30 | Dec-18 | |
Sheet 2 | |||
Oct-19 | Nov-19 | Dec-19 | |
John James Smith |
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>