If there was a dedicated column for SE, SW, NE, NW etc..then I would just filter the column for what you need.

If not, maybe vlookup for the direction you want first, and copy into a new sheet and repeat for all directions.


" What's that old saying.....
Never let your spouse leave the house horny or hungry, because their is always a whore with a sandwich out there. "