Forum Discussion
Solved
finding the year in a range of cells
Hello everybody, I'm trying to find a way that I can work out the year for every cell in a column, without having to individually type "YEAR (a1), Year (a2)….etc". The column could hold 65000 ce...
Hi Jeff,
Few variants
- you may pivot your source by year and month added in data model;
- you may use formula as SUMPRODUCT
- you may use Power Query
perhaps something else
Sample is attached.
Exactly what I was looking for, I used sumproduct