Cantonalives
Member
Hi all,
I know I should know this one but having something of a challenge here.
Sample attached. Basically I want to pull all of the data highlighted in yellow, into the cells in green. I cannot do anything about the format in yellow.
The Project is determined by the dropdown in red. This is where I am running into a road block. Pulling the first few cells with the right data is ok, but how do I then find the first month, which is determined by it being the first month with any value other than 0 and the subsequent data?
Any support much appreciated.
Thanks,
-CL
I know I should know this one but having something of a challenge here.
Sample attached. Basically I want to pull all of the data highlighted in yellow, into the cells in green. I cannot do anything about the format in yellow.
The Project is determined by the dropdown in red. This is where I am running into a road block. Pulling the first few cells with the right data is ok, but how do I then find the first month, which is determined by it being the first month with any value other than 0 and the subsequent data?
Any support much appreciated.
Thanks,
-CL