Hi.
I have a raw data tab with data that consists of a list of names (column A)
with an associated numerical data column (column B).

On a separate "Report Summary" tab in the same spreadsheet, I want to be
able to place names (from the raw data tab) in one section of rows if the
name's associated data is greater than zero and in another section of rows if
it's equal to or less than zero.

How can I do this without sorting the raw data? I want to be able to update
the raw data each month and have my report automatically place names into two
sections of rows -- those with values greater than zero and those with values
flat/less than zero.

Thanks in advance for your help!


Thanks,
Carmen