I have a large sheet that is sorted by file # & then by state with a ton of
other insignificant data in other columns. What i need is the first & last
file # for a particular state. is it easier to use 2 formulas for each
state: begin (which i can figure out how to get) and end (a little more
difficult to get). or would a macro work better (i wouldnt even know where
to start).

Any ideas?