we are attaching a file which we want to filer out the 1 true after false
how can it be done
EGmr 01-DafHaY R Mos M Weiss TRUE
EGmr 01-DafHaY R Mos M Weiss TRUE
EGmr 01-DafHaY R Mos M Weiss TRUE
EGmr 01-DafHaY R Mos M Weiss TRUE
EGmr 01-DafHaY R Mos M Weiss FALSE
EGmr 01-DafHaY R Mos Gold TRUE

look were the false & true comes up when we filter we need the new name row
not all the true's only the first true after false

"dk" wrote:

We need to autofilter & Copy only records that contain "true" after false
not all the "true" records?
also limit the cells to information not to 65000 etc