Forum Discussion
Question related to year
Hello Everyone, I am just wondering how to use dcount() function or any function that could result to find the count of the year as shown below in the picture. Please help...???
Considering the data in column A, you have list of years are unique ,,, so if you want to count the year, you get 1 for each.
But I don't this is the issue,, if you want to count that how many years are involved to get 36000 then you need an array formula or Solver can do this also.
So better edit your post & clear the issue,,, or share the expected output with us.