Thread: =IF(C1=""," ","ImportID-01")
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
  
Posts: 733
Default =IF(C1=""," ","ImportID-01")
Outlook, eh? wrote...
....
=IF(M2="","","ImportId-"
&TEXT(SUMPRODUCT(--ISNUMBER(SEARCH("Import",$K$1:K1)))+1,"00"))
....

Maybe try

=TEXT(SUMPRODUCT((TRIM(M2)<"")*(TRIM(M
$2:M2)<"")),"""ImportID-""00;;")

Reply With QuoteReply With Quote