Forum Discussion
JamesStewartExcel
Apr 05, 2019Copper Contributor
Help me get my dream job (Sorting per multiple row conditions) WARNING: Complicated
Hey guys, so I'm currently on an internship for a major tech company and they've lightheartedly said that if I fix a specific IT issue, they will give me a job there. ...However, in order...
Arul Tresoldi
Apr 08, 2019Iron Contributor
JamesStewartExcel have you the authority to add columns (and maybe hide them) in this file?
You can combine the columns you need (A&Q&S) to read out the string+classification1+idv and then assign a rank based on the order pointed out; then order by that new column and voilà...
JamesStewartExcel
Apr 08, 2019Copper Contributor
Arul Tresoldi Hey Arul! This sounds very interesting, I hadn't considered this at all. I have absolute freedom with the spreadsheet.
Could you clarify or explain a bit more about this approach? I'm not entirely sure I understand what you mean about combining them and reading it. But I'd love to hear more about it!