Boolean Searches in Excel


  1. Posts : 55
    Windows 10
       #1

    Boolean Searches in Excel


    I am working in Excel. My spreadsheet is several thousand rows long. It is filled with cells that have hundreds of lines of character text per cell (Excel was not the right app for this content, but someone else created it, not me). I'm doing keyword searches using Ctrl+F. Is there a way to do Boolean searches? For example:
    • reactor AND head AND stud
    • reactor NOT steam
    • stud OR bolt

    Or is this not possible in Excel?
      My Computer


  2. Posts : 15,481
    Windows10
       #2

    Excel Boolean logic: How to sift spreadsheet data using AND, OR, NOT, and XOR | PCWorld

    I doubt you can directly do it with the find.

    You would need to put the search paramers in a formula.
      My Computer


  3. Posts : 8,104
    windows 10
       #3

    Simple use chatgpt it will give you a function or code
      My Computer


  4. Posts : 55
    Windows 10
    Thread Starter
       #4

    The image below is a simplified example of what I have. In other words, the cells of my spreadsheet have long character strings, forming one or more sentences per cell. How do I set up a search to find all cells having the word "brown" in them? What command will do that?

    Boolean Searches in Excel-excel-search.png
      My Computer


  5. Posts : 16,939
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #5

    I suggest you create a header row, select it and apply the Filter to your top row so that you can use its capabilities.
    You'll find Filter in the right-hand side of the Home tab in the group Sort & Filter.
    Boolean Searches in Excel-excel-filter.png
    Then click on these dropdown arrows to see what you can do with filters.
    Boolean Searches in Excel-excel-filter-use.png

    Filter is quite capable on its own and you can read about more sophisticated filters in, for example, https://support.microsoft.com/en-us/...c-4877ad80c759


    Denis
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 17:21.
Find Us




Windows 10 Forums