Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0301· OpenAIAi2 WildChat-4.8M (AI2)

hi

  1. User

    hi

  2. Assistant

    Hello! How can I assist you today?

  3. User

    hi

  4. Assistant

    Hello! How can I assist you today?

  5. User

    give me formula in excell365 search at 4 table used filter function and vstack function together one formula

  6. Assistant

    Sure, here's an example formula that uses the FILTER and VSTACK functions to search in 4 tables in Excel 365:

    =VSTACK(FILTER(Table1[Column1],Table1[Column2]=SearchText),FILTER(Table2[Column1],Table2[Column2]=SearchText),FILTER(Table3[Column1],Table3[Column2]=SearchText),FILTER(Table4[Column1],Table4[Column2]=SearchText))

    In this formula, replace "Table1", "Table2", "Table3" and "Table4" with the names of your tables and "Column1" and "Column2" with the actual column names you want to search and filter by. Replace "SearchText" with the text you want to search for.

    This formula will search for "SearchText" in the second column of each table and return a vertical stack (row-wise) of the matching values in column 1 of each table.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.