I am looking up everything in a column that has a "1" in it,(meaning there is
something due this week), and listing it's corrisponding value in a list of
items. Problum, if there is more then one thing due that week it only lists
one and not the others. Any suggestions?

Assuming that Column B is used to designate whether an item is due, and
Column C contains the corresponding values of interest, try the
following formula which needs to be confirmed with CONTROL+SHIFT+ENTER,
not just ENTER...

E2, copied down:

=IF(ROWS(E$2:E2)<=COUNTIF($B$2:$B$100,1),INDEX(C$2 :C$100,SMALL(IF($B$2:$B
$100=1,ROW($B$2:$B$100)-ROW(B$2)+1),ROWS(E$2:E2))),"")

Adjust the range accordingly.

Hope this helps!

In article ,
Robert Brown wrote:

I am looking up everything in a column that has a "1" in it,(meaning there is
something due this week), and listing it's corrisponding value in a list of
items. Problum, if there is more then one thing due that week it only lists
one and not the others. Any suggestions?

What is the E2 stuff for?

"Domenic" wrote:

Assuming that Column B is used to designate whether an item is due, and
Column C contains the corresponding values of interest, try the
following formula which needs to be confirmed with CONTROL+SHIFT+ENTER,
not just ENTER...

E2, copied down:

=IF(ROWS(E$2:E2)<=COUNTIF($B$2:$B$100,1),INDEX(C$2 :C$100,SMALL(IF($B$2:$B
$100=1,ROW($B$2:$B$100)-ROW(B$2)+1),ROWS(E$2:E2))),"")

Adjust the range accordingly.

Hope this helps!

In article ,
Robert Brown wrote:

I am looking up everything in a column that has a "1" in it,(meaning there is
something due this week), and listing it's corrisponding value in a list of
items. Problum, if there is more then one thing due that week it only lists
one and not the others. Any suggestions?

As an example, I chose to return the results in Column E, starting at
E2. As the formula is copied down the column, ROWS(E$2:E2) returns a
series of numbers (1, 2, 3, etc.). The IF statement, which includes
ROWS(E$2:E2)<=COUNTIF($B$2:$B$100,1), ensures that a cell remains blank
when there are no other records that meet the criteria.

Does this return the desired result?

In article ,
Robert Brown wrote:

What is the E2 stuff for?

"Domenic" wrote:

Assuming that Column B is used to designate whether an item is due, and
Column C contains the corresponding values of interest, try the
following formula which needs to be confirmed with CONTROL+SHIFT+ENTER,
not just ENTER...

E2, copied down:

=IF(ROWS(E$2:E2)<=COUNTIF($B$2:$B$100,1),INDEX(C$2 :C$100,SMALL(IF($B$2:$B
$100=1,ROW($B$2:$B$100)-ROW(B$2)+1),ROWS(E$2:E2))),"")

Adjust the range accordingly.

Hope this helps!

In article ,
Robert Brown wrote:

I am looking up everything in a column that has a "1" in it,(meaning
there is
something due this week), and listing it's corrisponding value in a list
of
items. Problum, if there is more then one thing due that week it only
lists
one and not the others. Any suggestions?

Yeh that helps, i was hoping to get them in one cell, but i can manage,
unless you can figure it out.... THank you for your help though!

"Domenic" wrote:

As an example, I chose to return the results in Column E, starting at
E2. As the formula is copied down the column, ROWS(E$2:E2) returns a
series of numbers (1, 2, 3, etc.). The IF statement, which includes
ROWS(E$2:E2)<=COUNTIF($B$2:$B$100,1), ensures that a cell remains blank
when there are no other records that meet the criteria.

Does this return the desired result?

In article ,
Robert Brown wrote:

What is the E2 stuff for?

"Domenic" wrote:

Assuming that Column B is used to designate whether an item is due, and
Column C contains the corresponding values of interest, try the
following formula which needs to be confirmed with CONTROL+SHIFT+ENTER,
not just ENTER...

E2, copied down:

=IF(ROWS(E$2:E2)<=COUNTIF($B$2:$B$100,1),INDEX(C$2 :C$100,SMALL(IF($B$2:$B
$100=1,ROW($B$2:$B$100)-ROW(B$2)+1),ROWS(E$2:E2))),"")

Adjust the range accordingly.

Hope this helps!

In article ,
Robert Brown wrote:

I am looking up everything in a column that has a "1" in it,(meaning
there is
something due this week), and listing it's corrisponding value in a list
of
items. Problum, if there is more then one thing due that week it only
lists
one and not the others. Any suggestions?