A Alok Mishra New Member Jan 24, 2023 #1 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 Test File.xlsx 10.3 KB · Views: 5
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.
B bosco_yip Excel Ninja Jan 24, 2023 #2 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))),"")
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))),"")