+ Reply to Thread
Results 1 to 1 of 1

Match specific numbers of two different files and do sum of values ahead of that numbers

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2007
    Posts
    240

    Match specific numbers of two different files and do sum of values ahead of that numbers

    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.
    Attached Files Attached Files
    Last edited by keshavtale; 02-15-2020 at 02:48 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1