Excel CONTAINS function - Check IF a value exists in a range

แชร์
ฝัง
  • เผยแพร่เมื่อ 1 ต.ค. 2024

ความคิดเห็น • 7

  • @alderusan
    @alderusan 6 หลายเดือนก่อน +5

    I don't have the contains function

    • @excelkid
      @excelkid  6 หลายเดือนก่อน

      Hi, this function - alongside 200+ other powerful functions - is part of a free portable add-in that works within the Microsoft Excel environment. You can find more information here: excelkid.com/add-ins/

    • @matthewbriggs9414
      @matthewbriggs9414 5 หลายเดือนก่อน +2

      @@excelkid Why are the packages not available via the official Office Add-ins store? Downloading and executing the contents of zip files seems unnecessarily sketch.

    • @markmakineste
      @markmakineste 3 หลายเดือนก่อน

      @@excelkid Has anyone verified the trustworthiness of this add in?

    • @excelkid
      @excelkid  3 หลายเดือนก่อน

      We have been developing this add-in for many years, and our goal is to help people, not to cause harm. Please send us a message at support@excelkid.com, and we will send you the unencrypted version of the add-in. You can check every single line of code in it.

    • @excelkid
      @excelkid  3 หลายเดือนก่อน

      VBA add-ins cannot be uploaded to the Office Add-in Store. I don't know the reason for this. The reliability of a VBA add-in is just as easy to verify as that of a JS add-in.

  • @Marcus-n8s
    @Marcus-n8s 2 หลายเดือนก่อน

    Very useful function but how do I modify it if I want to find if a list of numbers contains the digits 2,3,5,and 7 only (so I can highlight the cells containing these numbers) as i need to keep only "Prime-free" numbers (in base 6)