Autocopy the first cell with more than 30 characters to a different sheet?

[Simensg]

Hi. I am using Excel 2010.

I have a workbook with a web query.

Is it possible to autocopy the first cell that has more than 30 characters to a different sheet?

It would help me a lot, because I then could see if there were any changes from the Website.


Example:


"Sheet1"

Range F1:F238.


F1:F20 String < 30 characters. Don't autocopy

F21: => 30 characters. Then copy to "sheet2" A1


Thanks in advance.

 

[NARAYANK991]

Hi ,


Is this what you are looking for ?


=INDEX(List,MIN(IF(LEN(List)>30,(ROW(List)*(LEN(List)>30))-MIN(ROW(List))+1,99999)))


Enter this as an array formula , using CTRL SHIFT ENTER.


List is a named range referring to $F$1:$F$238


Narayan

 

[Simensg]

Thanks! You are a genius!