Assignment 19 String Function Mid name and unique entries

Assignment 19

String Function

Mid name and unique entries

Function Used

MID :- This function gives number of character from the middle of text.

SEARCH:- This function use to find specific text in a string and give the number of location in string.

Index Function :- The Excel index function return the value at a given position in a range or array you can use index to retrieve individual values or entire rows and columns. Index is often used with the Match function, where Match locates and feeds a position to index.

Match Function :- The Excel Match Function is use to locate the position of a lookup value in a row, column or table.

Function for "MID name"

=MID(C3,SEARCH(" ",C3,1)+1,SEARCH(" ",C3,SEARCH(" ",C3,1)+1)-SEARCH(" ",C3,1))

(-) This operator will subtract the last search function

Function for "Unique Entries"

{=IFERROR(INDEX($C$3:$C$14,MATCH(0,COUNTIF($E$2:E2,$C$3:$C$14),0)),""))}

It is array function press ctrl+shift+enter

Note :-

In this assignment there are some name is given you have to insert suitable function so in the mid name (D) there should show middle name from the name (C) id there is only first name and last name then the last name should be printed in mid name (D) if their is only one name is present then that should be print only first name in column (D).

There is another column too named as Unique entries you have to use any function so total unique entries should be print in column(E).