i have done quite a lot with excel in the past, mainly using vb scripts. but this one for some reason has me flumoxed.
i have two columns of data. could be numbers coulc be text (will only be one or the other though - ie either two columns of numbers or two columns of text.
i need to compare the data in the columns such that it tells me how many more occurances of a piece of data are in the first column compared to the first.
for example if column a had 1,2,2,2,3,4,4 and the second column had 2,2,3,4 i would want the spreadsheet to tell me that there were that there is 1 occurance of 1, 2 of 2 and 1 of 4 that is in the first column but not the first. if it could just output each instance in the first not in the second as a list, that would be fine as i can take it from there.
many thanks for your help. this one has really been bugging me.