Hi Guys. Regarding excel is there a way we can sort a spreadsheet by variable then sort within each variable alphatetically? so as an example sorting by a buliding name then within each building name sorting by room no? my knowledge of excel is virtually zero so any advice will be welcomed..
Thanks in advance
David