i tried to write VBA code for below condtion which doesn't make any sense :(
code is for comparison - that is if C[1] is having the value same as C[3] then A[1] & A[3] values should be combined together with comma. for instance: consider that C[1] & C[3] having "split" then corresponding A[1]...