Hello Friends
If the cells C4:C43 have 1 then the corresponding value in the cells B4:B43 need to be plotted in the light yellow cells E4:E40 by formulas.
thanks in advance
Hello Friends
If the cells C4:C43 have 1 then the corresponding value in the cells B4:B43 need to be plotted in the light yellow cells E4:E40 by formulas.
thanks in advance
Sekar
E4=iferror(index($b:$b,small(index(($c$4:$c$43<>1)*10^10+row($c$4:$c$43),0),rows(e$4:e4))),"")
try this and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
This array formula** entered in E4:
=IFERROR(INDEX(B:B,SMALL(IF(C$4:C$43=1,ROW(C$4:C$43)),ROWS(E$4:E4))),"")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Copy down until you get blanks.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hello Siva and Biff
Thanks & thanks you formula working well and helped me lot.
thanks again
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks