View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Sumproduct question

LOL!

Ah well, if you're in a doctor's surgery or hospital, then you might
get something to treat that!! <bg

Pete

On Jan 29, 8:13*pm, John in Wembley wrote:
On Tue, 29 Jan 2008 12:10:20 -0800 (PST), Pete_UK

wrote:
Does it matter if the name is very long? Why not just test for length
being greater than 1 (i.e. your first term)?


Thanks Pete, good observation.
Im scratching my head for an excuse to why I did that!
so far no go, just red patch on scalp.

cheers