I attached two files, match numbers between of two files then do sum of values ahead of that numbers , in this instance
in file which name is mandi in that file if i select range N5 to N550 in that range you can see numbers like 636,646,679 and so on,
ahead of that numbers there is some values , in cell N4 number is 636 ahead of that number in cell Q4 value is 244,
in cell N5 there is number 646, that 646 number also in cell N34 so make sum of values which is ahead of number 646, here is sum is 340 (60+280=340)
so count the value of 646 number's is 340 then match this numbers with numbers which is in file which name is MRN but there you find number
like for example number 636 , this 636 you can found in file MRN like M636 so treat both numbers as same (or duplicate) , then match values
ahead of that number in MANDI file number 646 value ahead of that number is 340, in MRN file number M646 value ahead of number is 340 which is in cell C33
then do sum of values ahead of that selected numbers in selected range which i selected in file MANDi then match sum of both files if not match highlight
that numbers in green colour which values not match which is ahead of that numbers.
Bookmarks