필터 지우기
필터 지우기

Matching two data sets and return its position in one of the sets.

조회 수: 1 (최근 30일)
krysten spencer
krysten spencer 2021년 6월 8일
편집: krysten spencer 2021년 6월 8일
I have two excel data sets with the following information
Old Contact info: School name, address, city, postal code, province, phone number
New contact info: ID NUMBER, School name, address, city, postal code, province, phone number
I would like to get the ID number for all of the new contact information and match it next to the old contact info based on school name, city, province, and the postal code- but I would like it so that the text does not have to be an exact match for the school name. So basically next to the old school information I would like a column that shows the ID NUMBER for the data that matches from the new contact info (its location) plus all the information from that new contact.
That way I will have a blank cell for any old school contact info that is not in the new list (meaning it closed or moved addresses).
I have very little experience with MATLAB so any help getting started would be great.

답변 (0개)

카테고리

Help CenterFile Exchange에서 Install Products에 대해 자세히 알아보기

태그

제품


릴리스

R2018b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by