Hi,
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.
HOWEVER;
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.
Cheers,
-Roland
You Sort on column A
Create a column next to your sorting column, new column B,
you can even make it hidden if you want,
then enter a formula in column B, like, =IF(A1=””,”zzzzzzz”,A1)
and then sort on column B.
MIKE
http://www.skeptic.com/