How to get reference of duplicate value and set remove duplicate value for future entries

Dear forum,

Thanks once again for all your prompt response and support. Today i have come for 2 technical guidance. The requirements as below:

Requirement of Guidance: 1 - How to get the reference of duplicate value:

1. I have a master sheet in excel, which includes individual person's personal details (Age, Gender, Occupation, etc.,) in column followed by their name.
2. The master sheet is updated by day to day basis, those who are visited to counseling center.
3. Each and every time i have to enter each person's personal details (Age, Gender, Occupation, etc.,),if they visit.

My requirement is: "While i will enter the name of the person, i need to get their personal details automatically in the respective followed column.

Requirement of Guidance: 2 - How to set remove duplicate value in future entries:

1. In continuation of updating master sheet. i have set individual person's data extraction sheet separately. For example: If i want to know only about Mr. X and his number visit and counseling details. I have a field includes only unique value of individual(name) and if i select Mr. X name, the table set, which i have created will show the details of him.
2. To set this sheet, i need to get unique value (No. of individual visited to clinic) of individual. I know, it is very ease to remove duplicates from the available list. But...

My requirement is: I want to get automatic remove duplicate option for future entries. For example: Mr. X has already visited 3 times to counseling center. If Mr. X will visit to counseling center his 4th time next month, i should not get add Mr. X's name again in the drop down list.

Kindly do the needful for the above required support.

Thanks in advance

Bala

Dear Forum,

I got the following link to solve my required technical guidance. Anyway thanks for viewing my thread.

reference: https://www.youtube.com/watch?v=3u8VHTvSNE4