View Single Post
  #4   Report Post  
shellshock
 
Posts: n/a
Default


Scott, that's a neat idea with the autofilter, although I would need to
write a macro in order for that to happen automatically. (My file is
updated on an ongoing basis by several people, and I wouldn't want to
have to do that operation manually.)

Earl, I didn't even know about the LEN function until just now -- and
I think I was only vaguely aware of the ISTEXT function. In the end, I
did something very much along those lines: (=IF(B1<"", *my operation*,
""))

Thanks very much to both of you. :)


--
shellshock
------------------------------------------------------------------------
shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935
View this thread: http://www.excelforum.com/showthread...hreadid=385124