Yahoo Αναζήτηση Διαδυκτίου

Sign In

Αποτελέσματα Αναζήτησης

  1. stackoverflow.com › questions › 1285686Excel: Use a cell value as a parameter for a SQL query

    24 Αυγ 2015 · I'm using MS Excel to get data from a MySQL database through ODBC. I successfully get data using an SQL query. But now I want that query to be parameterized. So I wonder If it is possible to use a cell value (a spreadsheet cell) as a parameter for such a query. For example, for this query: select name from user where id=1

  2. www.ablebits.com › office-addins-blog › excel-find-search-functionsExcel FIND and SEARCH functions with formula examples - Ablebits

    21 Μαρ 2023 · How to use FIND and SEARCH in Excel - formula examples. Find a string preceding or following a given character; Find Nth occurrence of a given character in a cell; Extract N chars following a specific character; Find and extract text between parentheses

  3. www.exceldemy.com › excel-find-text-in-range-and-return-cell-referenceFind Text in Excel Range and Return Cell Reference (3 Ways)

    25 Ιουν 2024 · Method 1 – Use the INDEX and MATCH Functions to Find a Text in Range and Return a Cell Reference. We will search the text in a single column and the formula will return the reference to that cell. Steps: Select cell D17 to keep the result. Use the following formula in the D17 cell.

  4. support.microsoft.com › en-us › officeLook up values with VLOOKUP, INDEX, or MATCH - Microsoft Support

    Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.

  5. querystorm.com › query-function-for-excelQUERY function for Excel – how to use SQL in Excel cells

    26 Σεπ 2022 · However, Excel doesn’t natively have a QUERY function that you can use in cells on the sheet. In this blog post, I’m going to show you how to add a QUERY function to Excel and give a few examples of how to use it.

  6. www.ablebits.com › office-addins-blog › excel-match-functionExcel MATCH function with formula examples - Ablebits

    20 Μαρ 2023 · See how to match data in Excel using the MATCH function. Basic uses and advanced formula examples for case-sensitive match, Vlookup and Match, and more.

  7. support.microsoft.com › en-us › officeLookup and reference functions (reference) - Microsoft Support

    Expands or pads an array to specified row and column dimensions. FILTER function. Filters a range of data based on criteria you define. FORMULATEXT function. Returns the formula at the given reference as text. GETPIVOTDATA function. Returns data stored in a PivotTable report. HLOOKUP function