I’m coordinating a project among several people, sorting through data on a response sheet. Multiple rows correspond to a single response sheet number. So, for Example, "Response 1521"would encompass 15 rows of data. I wanted to sort them, and have all the rows show up in the right place. So in the first column, I put “1521(1),” “1521(2)” etc.
Problem is, 1521(10) and 1521(11) come up before 1521(2). Which I didn’t want it to, thus the brackets. Is there a better way to do what I’m trying to do? I’m clearly in way over my head.