Forum Discussion
Sort by row number unique values erroneous error
I think you're misunderstanding the message. "error that says the row number value needs to be unique for each id value" - that's not what it says.
It says "There can't be more than one value in row# for the same value in id" so it's looking at , for example id = a and saying, "right, what value do i use to sort this" and it gets 1,2,3,4,5,6 etc. so it doesn't know what to do. What it wants is 1 value for "a", 1 value for "b" and so on.
Now, all that explanation doesn't really help you sort your data but at least you'll know what's happening.
I think you're misunderstanding the message. "error that says the row number value needs to be unique for each id value" - that's not what it says.
It says "There can't be more than one value in row# for the same value in id" so it's looking at , for example id = a and saying, "right, what value do i use to sort this" and it gets 1,2,3,4,5,6 etc. so it doesn't know what to do. What it wants is 1 value for "a", 1 value for "b" and so on.
Now, all that explanation doesn't really help you sort your data but at least you'll know what's happening.