Thread: Comparing text in columns
View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default Comparing text in columns
On Mon, 18 Apr 2011 06:43:51 -0700 (PDT), wrote:

How can this be modified to deal with blank cells in the 'wordlist'
column?

Thanks!

I don't know how to modify the formula to do that. Perhaps some lurker can figure it out, if it is possible.

I would either use a VBA User Defined Function, or, if that is not allowed by your company, I would ensure that there are no blank cells in WordList.

The VBA UDF would be based on what I presented in my second response to you a few days ago. If that is what you want, you can either modify it yourself or, if you will present a full list of specifications in a single message, (as opposed to one new specification per message, which is what you have been doing), I would be happy to make the appropriate modifications.
Reply With QuoteReply With Quote