Home 
Search 
Today's Posts 
#1




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? 
#2




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? 
#3




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? 
#4




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? 
#5




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? 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Copying a formula to multiple worksheets  Excel Worksheet Functions  
Match then lookup  Excel Worksheet Functions  
abdualmohsn  Excel Discussion (Misc queries)  
Formula to return cell contents based on multiple conditions  Excel Worksheet Functions  
Function Formula is displayed not results  Excel Worksheet Functions 