Thread: Global Change Of Formula Value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 620
Default Global Change Of Formula Value
On 21/10/2011 20:23, carl wrote:
=(SUMPRODUCT(--($E$42:$E$22956=549);--(LEFT($C$42:$C$22956;2)=C$5);--
($G$42:$G$22956="SailErrorNotice");$A$42:$A$22956) )

Find and replace.

David Biddulph
Reply With QuoteReply With Quote