About Us

ExcelBanter AI

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Worksheet Sort - but all sheets in array do not exist	[email protected]	Excel Discussion (Misc queries)	2	August 20th 06 02:41 AM
find value in array on sep sheet & ret correspond val from col lef	learningasigo	Excel Discussion (Misc queries)	5	June 25th 06 09:22 PM
Creating an array to find months	ssrvant	Excel Worksheet Functions	4	June 24th 06 01:49 AM
how to find all matches in an array	Greg	Excel Discussion (Misc queries)	2	August 31st 05 09:04 PM
How do I find a value in an array (VLOOKUP? HLOOKUP?)	M Skabialka	New Users to Excel	2	March 11th 05 02:52 AM

Menu

About Us