View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Need help creating a formula

On Fri, 28 Dec 2007 14:30:20 -0800, "DonV" wrote:

I figured it out, I can't do the testing on the same sheet, need to have the
table on a separate sheet. Now it works.

Thanks Ron for your help and patience.


Don,

You certainly CAN have the table on the same sheet. Just put it someplace "out
of the way", where it won't be seen under ordinary circumstances. You can even
"hide" it by collapsing the columns.

But I'm glad you've got it working.
--ron