Apply array formulas

Apply array formulas

  1. To apply array formulas:
  2. Select the cells in which you want the resultant array (the result of the output formula) to
  3. be present.
  4. Type the array formula you wish to apply over the array. Like other formulas, an array formula is preceded by an "equals" (=) sign.
  5. You may find it comfortable to name the array you plan to use as input by using 'Define Name' feature found in the context menu.
  6. After you enter the formula, press Ctrl + Shift + Enter instead of Enter alone.
  7. The array formula will be executed.

    • Related Articles

    • What are Array Formulas

      Array formulas are used when a set or group of numbers are to be considered as input or output data for operators. These formulas are generally applied when the data is used in a group together.

    • Quick Apply

      Zoho Recruit's Quick apply integrations allow candidates to fill out your job applications using their information on the respective job board with just a click of a button. Candidates can find the jobs that you've published on these job boards and ...

    • Apply Filter

      To apply filter: 1. Select the column or range of cells to be filtered. 2. Click Data> Filter or use the Filter icon  from Toolbar or right click on the selected range and select Filter from the context menu. 3. Choose the required filtering ...

    • Apply a named filter

      To use or apply a named filter, Click on the dropdown arrow on the   icon in the toolbar and choose Named Filters. From the list of named filters, choose the filter you wish to apply. The filter will be applied on the specified range saved along with ...

    • Apply Now Button

      To rename the Apply Now button on a Job List Navigate to Setup > Portal Setup > Career Site. Click the Customize/Edit page icon beside the job listing page on which you would like to rename the Apply Now button. On the Job List, click Customize. On ...