You're welcome!

--
Biff
Microsoft Excel MVP


"jcheko" wrote in message
...
thanks that worked very well!!!

"T. Valko" wrote:

Hard to tell without seeing the *exact* formula you tried but this is
usually where the "trouble spots" a

=IF(ROWS(D$1:D1)...............ROWS(D$1:D1)......)

Whatever the *first* cell address is where you're entering the formula,
use
that address in the ROWS function. If the *first* cell to hold the
formula
is H14, then:

=IF(ROWS(H$14:H14)...............ROWS(H$14:H14)... ...)


--
Biff
Microsoft Excel MVP


"jcheko" wrote in message
...
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?