LinkBack URL
About LinkBacks
hi,i need to extract c1:c5 or d1:d5 at a1:a5 if b1 =1 or 2 without an array formula ,how is that possible))?
hi,i need to extract c1:c5 or d1:d5 at a1:a5 if b1 =1 or 2 without an array formula ,how is that possible
perhaps this?
=SUM(IF(B1=1,C$1:C$5,D$1:D$5))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
please see attachement ,i use an array formula at a1 but i need to use something else becouse arrays make the computer slower.thanks brother
Did you even try my suggestion?
yesand it gives me the number 15 and if i drag down gives 40,40...
yes, and that is the sum of col C? What were you expecting?
dear FDibbins ,i expect to extract the numbers to a1:a5 if b1=1 or b1=2 not to sum
if you see my file at #3 i have an array formula which doing the jiob but i need to do the same without array.thanks
Last edited by zzz444; 05-25-2020 at 12:45 AM.
OK try this then...
=INDEX($C$1:$D$5,ROWS($1:1),$B$1)
Formula:
Please Login or Register to view this content.
may be this
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
No, it seems the OP wants each entry extracted to col A, not summed. My 1st suggestion also did what you are trying...Originally Posted by avk
Formula:Please Login or Register to view this content.
may be this
=SUM(IF(B1=1,C$1:C$5,D$1:D$5))
yes!,super.but when b1 is empty or zero i get at a1:a5 #VALUE! how can be just blanked?
#VALUE!
#VALUE!
#VALUE!
#VALUE!
=if(B1-"","",INDEX($C$1:$D$5,ROWS($1:1),$B$1))
is still gives the same#value
Sorry, left off the $$...
=IF($B$1="","",INDEX($C$1:$D$5,ROWS($1:1),$B$1))
i wish God gives You health and happiness!!! thanks
Happy to help, thanks for the wishes
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks