• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel problem for arrayformula

Alok Mishra

New Member
I want to create a formula where it takes the data from COlumn L and put it into column D but ensuring that it should only work where column C is not blank.
 

Attachments

  • Test File.xlsx
    10.3 KB · Views: 5
Here is a non-array formula solution.

In D2, formula copied down:

=IF(C2<>"",INDEX(L$2:L$10,AGGREGATE(15,6,ROW(L$2:L$10)-ROW(L$1)/(L$2:L$10<>""),COUNTA(C$2:C2))),"")


82592
 
Back
Top