How to do this in excel?? Help!

H2O — Fri, 01 Aug 2008 12:45:34 -0400

i have a bunch of the columns, one of them labels the stock to be either Long or Short. if i want to put all the long in one tab and all the short in another tab, so i can reference them separately from there on, what formula should i use so it updates automatically when the first sheet refreshes? No macro please. thanks in advance!

Would you buy condo in Manhattan right now?

H2O — Mon, 28 Jul 2008 14:25:03 -0400

for investment/living purpose, assuming money is not an issue.

Division at Goldman

H2O — Thu, 24 Jan 2008 14:17:21 -0500

How is GSAM regarded compare to FICC and Equities? What exactly do they do? thanks in advance for the info!

excel wiz: if you have a bunch of rows...

H2O — Tue, 09 Oct 2007 10:48:39 -0400

and you want to insert a blank row after each row, what's the fastest way to do it? thanks

Excel Wiz, Do You Know This?

H2O — Fri, 28 Sep 2007 09:18:33 -0400

if I want to refer to a fixed cell *location*, not value, regardless how i insert rows and cols, what do I do? using $ and names won't do. any idea?

HOW DO YOU DE-STRESS?

H2O — Mon, 08 Jan 2007 13:46:59 -0500

i'm miserable =(

Current/Former S&T - how to switch bank after year 1?

H2O — Tue, 31 Oct 2006 09:08:41 -0500

anyone know how it has been done? yes, you apply, but how? and how easy/difficult is it? thank you for your input

Telecom/Media Group

H2O — Fri, 29 Sep 2006 13:13:13 -0400

anyone in this group? what exactly do you do?