View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.newusers
dk dk is offline
external usenet poster
 
Posts: 129
Default Remove Duplicates

thanks for relying

We copied your code & we are attaching a file with results
EGmr 01-DafHaY R Moshe M Weiss TRUE
EGmr 01-DafHaY R Moshe M Weiss TRUE
EGmr 01-DafHaY R Moshe M Weiss TRUE
EGmr 01-DafHaY R Moshe M Weiss TRUE
EGmr 01-DafHaY R Moshe M Weiss FALSE
EGmr 01-DafHaY R Moshe 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

"Max" wrote:

Maybe it's because your problem description is so terse & vague that nobody
can quite understand what you're talking about. Suggest you elaborate and
illustrate your scenario fully, post the expression that you're using, etc.
Of course you need to be certain yourself what exactly is it that you want
to do. If you yourself are not clear what you want, how do you expect others
to be able to respond?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dk" wrote in message
...
we have put in new post already 1 day as autofilter special but no replies
so
maybe original idea is accurate because the change of true & false isn't
in
the righ row it's 1 row ahead?