K KIM Chanthan Member Jan 6, 2017 #1 Hi, Do you have any easy way to pick up value/text from the most left column? Attachments Pick up the most left column.xlsx 8.1 KB · Views: 14
B bosco_yip Excel Ninja Jan 6, 2017 #2 E1, copy down : =INDEX(A1:D1,MATCH(TRUE,INDEX(A1:D1<>"",0),0)) Regards
