Windows 10: Searching for spreadsheets that use a certain formula

Discus and support Searching for spreadsheets that use a certain formula in Windows 10 Network and Sharing to solve the problem; I'm using Windows 10 search to find any spreadsheet that uses a particular formula. The only results I get are files for which the formula is written... Discussion in 'Windows 10 Network and Sharing' started by Dan_#, Oct 11, 2019.

  1. DAN_#
    Dan_# Win User

    Searching for spreadsheets that use a certain formula


    I'm using Windows 10 search to find any spreadsheet that uses a particular formula. The only results I get are files for which the formula is written out in plain text in a cell. I don't get any hits for files that actually use the formula. I've tried wildcards before, after and both before and after; all to no avail. Any advice would be appreciated.

    :)
     
    Dan_#, Oct 11, 2019
    #1
  2. JOHNPANZO
    JohnPanzo Win User

    Request for a End-of-month formula for Mobile Excel and a complete list of supported formulas for Mobile Excel

    Hi,

    So I just have a couple of questions. They stem from my discovery that certain formulas are not supported by the Excel mobile app and that heading then will cause your spreadsheet not to be editable on your mobile app. Ab example of this is the end-of-month
    formula (eomonth()). So my two question are:

    What is an alternative way of implementing the end-of-month formula in my spreadsheet so that it can be editable on my mobile office app?

    Where can I find a list of formulas that are stored by the Excel mobile app so that this doesn't happen again?

    Thank you in advance,

    John Panzo
     
    JohnPanzo, Oct 11, 2019
    #2
  3. JL2509
    jl2509 Win User
    Anyone any good at spreadsheet formulas??



    Searching for spreadsheets that use a certain formula [​IMG]

    with your changed figures.
     
    jl2509, Oct 11, 2019
    #3
  4. TERESARUTLEDGE
    TeresaRutledge Win User

    Searching for spreadsheets that use a certain formula

    Simple spreadsheet will not allow editing

    I just bought an HTC Win 8 phone mainly for the built in Office suite. I emailed an Excel spreadsheet to the phone and like many others it will not allow editing. This spreadsheet has no formulas, it is a 3 column list of books, authors and dates.
    Has anyone found a workaround?
     
    TeresaRutledge, Oct 11, 2019
    #4
Thema:

Searching for spreadsheets that use a certain formula

Loading...

  1. Searching for spreadsheets that use a certain formula - Similar Threads - Searching spreadsheets certain

  2. FORMULA HELP- Excel : Using 2 sheets

    in Windows 10 Gaming
    FORMULA HELP- Excel : Using 2 sheets: The website will not allow me to add any photo of any kind, so I have made charts. : SHEET 1Cell down Row ->DF6Enter Country NameEquals Load1CameroonRows go from 6-127DATA sheet 2's nameCell down Row ->BC29COUNTRYLOAD PERCENT30Burundi100%31Cameroon400%Rows go from 29-70I need...

  3. FORMULA HELP- Excel : Using 2 sheets

    in Windows 10 Software and Apps
    FORMULA HELP- Excel : Using 2 sheets: The website will not allow me to add any photo of any kind, so I have made charts. : SHEET 1Cell down Row ->DF6Enter Country NameEquals Load1CameroonRows go from 6-127DATA sheet 2's nameCell down Row ->BC29COUNTRYLOAD PERCENT30Burundi100%31Cameroon400%Rows go from 29-70I need...

  4. FORMULA

    in Microsoft Windows 10 Store
    FORMULA: what formula can i use to get total hours worked per day. DATESTART TIMEEND TIMETOTAL HOURS6/1/202111:00AM12:06:00...

  5. Cell formulas in excel spreadsheets

    in Windows 10 Customization
    Cell formulas in excel spreadsheets: Can someone help me to I presume clear formatting in cells. I'm entering a column of numbers in this case planting space guides for vegetables and every once in awhile a random cell will revert to a date. For example, if you look down the column you see 15-30, 40-50, Oct-15...

  6. search file explorer for text inside of a spreadsheet

    in Windows 10 Network and Sharing
    search file explorer for text inside of a spreadsheet: I have a folder which contains spreadsheets from my vendor. Each one has a list of invoices for a period of time. I'm trying to search the folder using file explorer for a specific invoice number but there are no search results. To rule out the possibility that the record...

  7. Formulas

    in Windows 10 Network and Sharing
    Formulas: is there a way to use LOOKUP or any other formula to add values from a large number of different sheets in the same file? https://answers.microsoft.com/en-us/windows/forum/all/formulas/764e8940-6ae1-4aed-a8d0-dc28d60c4372

  8. cant use the formula datedif in excel.

    in Windows 10 Installation and Upgrade
    cant use the formula datedif in excel.: macro in this excel file tried to execute unknown application. the action is blocked for security reason. https://answers.microsoft.com/en-us/windows/forum/all/cant-use-the-formula-datedif-in-excel/f771495a-e955-4b85-841a-59b76fa7df5a

  9. Anyone any good at spreadsheet formulas??

    in Windows 10 Software and Apps
    Anyone any good at spreadsheet formulas??: Hi Guys I am reasonably able to do formulas but one I need is foxing me, I will try to show example. Cell A Cell B Cell x (profit) 100 150 50% I am displaying that A has made a 50% profit, but B will change from time to time so when B changes, I want X to show the...

  10. Search in certain files

    in Windows 10 Support
    Search in certain files: Hi, how can i search within the content of only certain files ? Also, is there a page that contains the list for all Win10 search functions ? I'm looking it up since 30 minutes but can't find anything. I need to seach the term blabla in all .doc files, how is that...