Hi Isa,
Yes, there is a function you can use to find out if a value exists in an array. You can use the "MATCH" function in Excel to do this.
Here are the steps to follow:
- Select the cell where you want to display the result of the search.
- Type the following formula:
Formula:
=MATCH("*HR*",A1:A10,0)
- Replace "*HR*" with the value you want to search for. In this case, you can use "*HR*" to search for any job title that contains "HR" or "Human Resource".
- Replace A1:A10 with the range of cells that contains the job titles you want to search through.
- Press Enter to display the result.
The result will be the position of the first cell in the range that contains the value you are searching for. If the value is not found, the formula will return an error.
You can also use the "COUNTIF" function to count the number of cells that contain the value you are searching for. Here are the steps to follow:
- Select the cell where you want to display the result of the search.
- Type the following formula:
Formula:
=COUNTIF(A1:A10,"*HR*")
- Replace A1:A10 with the range of cells that contains the job titles you want to search through.
- Press Enter to display the result.
The result will be the number of cells in the range that contain the value you are searching for.