difference – Useful code

VBA and Python – Intersection of dictionaries

Posted on April 4, 2021 by

Intersection of dictionary (or of any two lists) is a list with elements, that are present in both other lists. Thus, if we have the following 3 dictionaries in Python:

dict_a = dict([('aa', 4139), ('bb', 4127), ('cc', 4098)])
dict_b = dict(aa=4139, bb=4127, ee=4098)
dict_c = {'aa':12, 'bb':13, 'dd':23}

dict_a = dict([('aa', 4139), ('bb', 4127), ('cc', 4098)])

dict_b = dict(aa=4139, bb=4127, ee=4098)

dict_c = {'aa':12, 'bb':13, 'dd':23}

Then, an intersection of their keys will contain only…

VBA – Difference between Trim, VBA.Trim, =Trim() and WorksheetFunction.Trim

Posted on March 11, 2018 by

Vitosh Posted in VBA \ Excel

Trimming is a function, that reduces spaces. There are at least 4 ways to Trim a string in Excel/VBA: Trim VBA.Trim =Trim() WorksheetFunction.Trim Thus, is there a difference between these 4 actually? This is what MSDN says about String.Trim: Returns…

Tag: difference

VBA and Python – Intersection of dictionaries

VBA – Difference between Trim, VBA.Trim, =Trim() and WorksheetFunction.Trim