I seem to be running into a little (alright, maybe not so little for me) problem with my database in Excel.
I have the following general setup;
Page1 holds a 'master list' of data. Nice little rows of everything i need to have on file for each object in the list.
On Page2 i have a cozy family of VLOOKUP functions, which grab several of the colums of Page1 for every line, giving me sertain cets of attributed i can print into comprehendable lists.
Page1 is sorted, for convenience, by column a, in ascending order.
But I'd like Page2 to sort itself by column b, in descending order.
However, since there are a few dozen 'empty' cells (Holding a VLOOKUP that does not find anything to report.), these cells drift to the top of my descending list, pushing the data I actually need from view.
Evidently, my knowledge of the finer workings of Excel is, -ahem-, somewhat limited, so if there's anyone there who is now going; "Dude, just do *solution*!" I'd rather appreciate him or her speaking up.