quick question for you...I am trying to work the formula starting in cell 14
on another worksheet...and it brings it in blank, probably because it is
reading the first 13 cells before that one. and all of them are blank....in
this worksheet is were I have set up the report I print but I can't get it to
work....can you help with this.

"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"jcheko" wrote in message
...
that was very helpful, thank you.

"T. Valko" wrote:

One way:

A1:A100 = codes
B1:B100 = values

Enter this array formula** in D1:

=IF(ROWS(D$1:D1)<=COUNTIF(values,"<0"),INDEX(codes ,SMALL(IF(values<0,ROW(codes)-MIN(ROW(codes))+1),ROWS(D$1:D1))),"")

Copy down until you get blanks meaning the data has been exhausted.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"jcheko" wrote in message
...
I have two columns, one with cost codes and another the values of those
cost
codes....in another worksheet I need to bring in that information.
first
the
function has to read down the column with the values and if it
identifies
a
values greater than zero I need the function to bring in the cost code.
can
anyone help with this?