Share via

Comparing 2 Arrays and return missing values

Spence Southall 1 Reputation point
2022-07-01T15:10:32.073+00:00

I'm working on comparing 2 arrays to see who is missing from a list: 1st array has a name and license, "John Doe, Exchange Online" 2nd array just has names "John Doe".
If 2nd array is missing a name from the 1st array then it should return the full value from the 1st array
1st Array 2nd Array New Array
John Doe, Exchange Online John Doe Danny Smith, Enterprise Online
Danny Smith, Enterprise Online Scott Jones
Scott Jones, Exchange Online

217025-image.png

216977-image.png

Community Center | Not monitored

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.