showing multiple results to a formula
 

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?

showing multiple results to a formula
 

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?

showing multiple results to a formula
 

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?

showing multiple results to a formula
 

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?

showing multiple results to a formula
 

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?