Hello dear forum members,
I have a large data set for sale dates and times of various products.
I would like to add a column, that for each different type of product (product SKUs provided), would number the sales chronologically. By this I mean the earliest sale of each product would get "1", the sale after that one would get "2", and so on, from old to new, for each and every product in the sheet. This would of course be easy if there was only one product... however that's not the case...
I have uploaded a small sample of the data, for just 3 products, alongside what I hope to achieve. Here it is:
http://dl.dropbox.com/u/7112203/questionbook.xlsx
By the way, I must again thank jonmo1 and teylyn, without whom I would not have had the dates formatted properly!![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Thanks in advance!
I have a large data set for sale dates and times of various products.
I would like to add a column, that for each different type of product (product SKUs provided), would number the sales chronologically. By this I mean the earliest sale of each product would get "1", the sale after that one would get "2", and so on, from old to new, for each and every product in the sheet. This would of course be easy if there was only one product... however that's not the case...
I have uploaded a small sample of the data, for just 3 products, alongside what I hope to achieve. Here it is:
http://dl.dropbox.com/u/7112203/questionbook.xlsx
By the way, I must again thank jonmo1 and teylyn, without whom I would not have had the dates formatted properly!
Thanks in advance!