B bdbounds New Member Apr 15, 2010 #1 I have a worksheet with text in column B; want to list in column F the value in column D if true? Any help appreciated. Thanks, Diane
I have a worksheet with text in column B; want to list in column F the value in column D if true? Any help appreciated. Thanks, Diane
oldchippy Active Member Apr 15, 2010 #2 Hi Diane, Does this in D1 copied down work for you =IF(ISTEXT(B1),D1,"")