The FIND function is case sensitive. The FIND function will return the location of the first instance of find_text in within_text. In this list you want to find the number of names in which ansh or anka occurs.
Highlight cells D6 through F11 in the worksheet to enter the range into the dialog box.
Highlight cells D6 through F11 in the worksheet to enter the range into the dialog box. OFFSETA1MATCHE2A2A502 The formula uses the value Mary in cell E2 and finds Mary in column A. If you omit this argument the function will assume. Highlight cells D6 through F11 in the worksheet to enter the range into the dialog box.