KnowledgeInbox

Comparing 2 List of Values and finding differences

(5)

 Loading ...

Comparison between 2 different list of values to find the missing and additional parts can be complex task if the algorithm. Let us consider 2 different arrays
Array1 = {"a", "b", "c", "b", "f"}
Array2 = {a", "e", "d", "g"}
Now from visual inspection we can notice that
Array1 is missing “e”, “d” and “g”
Array1 has additional element “c” [...]

Register or Login to read the full article...

Tags used - array, arrays, between, compare, Comparison, difference, Find, lists, missing, two, values

Removing duplicate values from a List of Values

(4)

 Loading ...

A List of values may contains few duplicates and if we need to find the unique values out of the same then we need some algorithm to filter that out. Consider we have an array of values as give below

Dim arrLOV
 
arrLOV = Array ("Val1", "Vale2", "Val2", "Val1", "Val3", "Val2")

Now the array contains 2 duplicate values [...]

Register or Login to read the full article...

Tags used - duplicate, duplicates, filter, List, remove, unique, values