hi,
I have two columns. one with items sold, second with dates in which these items were sold. many of the sells in both columns are identical. I need to get a formula that counts a dividing result of total sales number per number of weeks.
for example:
NAME WEEK NUMBER
ITEM 1----------------2
ITEM 2----------------2
ITEM 1----------------3
ITEM 3----------------2
ITEM 2----------------2
RESULT:
ITEM 1 = 1
ITEM 2 = 2
ITEM 3 = 1
Bookmarks