“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I can`t open any excel file with 2010 Microsoft office

Solved by Z. A. in 24 mins

How can you type something in one cell and have excel reference that and type something simultaneously in other cell?

Solved by B. U. in 22 mins

Im trying use names on Sh2 and gen a list on Sht3 that show these names excluding duplicates, blanks, and any containing txt "E" if some cells in Sh1 arent blank. These forms can almost do this but they dont exclude names that contain "E": Form in cell 1: {=IF(COUNTIF('S2'!$T$2:$T$50,"*?")=0,"",IF('S1'!$D$2="","",IF('S1'!$D$3:$D$12="","",OFFSET('S2'!$T$2:$T$50,INDEX( MATCH(1,(--( 'S2'!$T$2:$T$50<>"")),0),1)-1,0))))} Form in cell 2: {=IF('S3'!$I$1="","",IF(COUNT(MATCH('S2'!$T$2:$T$50, 'S3'!I$1:I1,0))<COUNT(1/('S2'!$T$2:$T$50<>"")),INDEX('S2'!$T$2:$T$50,MATCH(0,('S2'!$T$2:$T$50<>"")-ISNA(MATCH('S2'!$T$2:$T$50,'S3'!I$1:I1,0)),0)),""))}

Solved by D. J. in 28 mins

Excel formula not working in columns Q thru T

Solved by O. A. in 24 mins

In excel i am not getting to type anything in that what can i do

Solved by C. J. in 19 mins