I have a table of data. One column has the month(1,2,3, etc) the next column has names and the 3rd column has quantity.
Whats a good way to calucate YTD on another sheet. The names wont nessesarily be the same every month and there will be the possibilty of multilple occurances of each name each month.
Im being tasked with showing YTD for each an the whole group.(jan- though current) and rolling 12 months.
thanks
Whats a good way to calucate YTD on another sheet. The names wont nessesarily be the same every month and there will be the possibilty of multilple occurances of each name each month.
Im being tasked with showing YTD for each an the whole group.(jan- though current) and rolling 12 months.
thanks