• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data sorting by order of appearance

Cyrius

New Member
I have a file with 6,000 rows of data and several columns. Data has product numbers and dates with time stamps. A product may appear several times during a day worth of data. My goal is to sort the data by day, but I need to show the order that the products appear on the list (For example, out of a list of 5 products the order that they show in a day might be "Product 4", "Product 2", "Product 1", "Product 3", "Product 5"). I tried to solve it using the following array formula,

={sum(if((Range1=date1)*(Range2=productcode1),productcode1,if((Range1=date1)*(Range2=productcode2,productcode2, if(.........until it covers all the codes


I cannot think of any other way of sorting this data.


THanks for your help.
 
Hi Cyrius,


You can use helper columns to strip out and hold the time, then sort the Data By Date Then By time


cheers

kanti
 
Back
Top