Thread: Insert value if not existing
View Single Post
 
Old 04-03-2020, 03:34 PM
Logit Logit is offline Windows 10 Office 2007
Expert
  
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
Paste in E2 :

Code:
=IF(COUNTIF(H2:H4,A9),"",A9)
Reply With Quote