I am trying to advance filter a spreadsheet containing housing information.
Namingly, one column is titled "lot type" with the corresponding data in that
column reading "Type 1" or Type 2,3 etc. I wish to sort the lots by my choice
of number from one to 11. nothing seems to work. I think perhaps I don't know
the correct code that excel will accept. Maybe an issue of text and numerical
data in the same cell? being brand new to filtering doesn't help either!