Hi,
This is Shreyas,I am doing a project where I am trying to create a start date and end date in separate columns where when we can choose any date as soon as the start and end date is chose the average values should be shown for a particular sector in a row so basically calculating average for a of a column for a row so that the result should show up when the dates are entered when in range.
EX
Start Date End Date
Dates Row Column1 Column2
5/21/2018 A1
5/24/2018 A2
The Average of column 1 Against Row and similarly average of column against row and so on.The average calculated value should show up automatically when the dates are entered
Any kind of suggestions would definitely help me Thanks!
Hi Shreyas
It is not clear from your description what you wanted.
Can you please attach a sample file with the expected result? Highlight the expected result.
It will help us to understand better your requirements.
Sunny
