i expect a similar kind of solution for my problem.
i have a list of 6 digit cheque numbers in ascending continuos serial order. for example, 223000,223001,223002.....etc. in one column 'A'.
then I have a list of 6 digit enchashed cheque numbers randomly in ascending oreder. i.e., 223002,237652, 238645,245674......etc like this in coumn 'B'
now I want to match these two columns and form a 3rd column with all un-encashed cheque nunbers.
akindly assume that all cheque numbers in column 'B' are defenitely available in column 'A'.
in terms of set theory, I want A-B ( here 'B' is a subset of set 'A').
kindly provide me with some solution for this