I have a problem with function GROUPBROWNUMBER(). I think it's a bug, hope you can help.
We use Personal Edition and Version 3.0.17 of Datameer.
My sheet contains 2 columns: ID and Date. Here's my base sheet: http://cl.ly/image/3z3N46070C14 (The two columns in the middle can be ignored.)
I want to use GROUPBROWNUMBER() to number the rows sorted by date. I sorted the sheet by date, so that earliest date is on top. Than I created a new sheet with these columns: GROUPBY on ID, GROUPBROWNUMBER() and COPY of date. The result is: http://cl.ly/image/1d083M3x3E0p
As you see the rows are numbered ascending, but the date in the second row is earlier than the date in the first row. As the base sheet is sorted by date, I don't understand why the new sheet is not sorted by date.
When I sort the new sheet by date, the earliest date is on top, but it has still number two in the column of GROUPBROWNUMBER(). I also tried to change order of columns of the new sheet into: ID, DATE, ROW NUMBER. Doesn't work, too.
Is this a bug of function GROUPBROWNUMBER() or am I doing something wrong?
Please sign in to leave a comment.