I have an excel question

[jme5343]

I've got a small ordering/inventory sheet I've worked up. I've added drop down boxes for customer and location. I'd like to be able to sort them geographically when needed, East and West. Can I hide something in the field that could be used to sort them this way?

Thanks for looking.

 

[richwenzel]

is this field an array?

if not, why not just add another column that has east/west, the sort function allows for multiple column selection...

lets say you had size and east/west, you could just order by east/west column and then order by size..., just select the whole area, and select order first by geography, than order second by size.

hope this helps.

 

[jme5343]

Thank Rich, I'll try that.