+ Reply to Thread
Results 1 to 6 of 6

macro or functions to identify same values in two columns

  1. #1
    Registered User
    Join Date
    11-17-2011
    Location
    Sri lanka
    MS-Off Ver
    Excel 2003
    Posts
    34

    Angry macro or functions to identify same values in two columns

    My problem is related to the excel sheet that i have attached here.In this work sheet you can see that there are 2 tables.There are 6 entries(values) under column C under the first table(C9:C14). First i should select first entry that is c9 and i should find which cell under column L consist with the value which is same as the value in cell C9.(in this example value of the cell C9=value of the cell L16). When that cell under column L is selected, the values in the row (D9:H9)(array of values) corresponding to the cell c9 should be multiplied with the values in the row(M16:Q16)(array of values) corresponding to the matched cell(L16) under column L and the results should be stored in the cell(I9) in column I which is corresponding to the cell (c9).And this should be done for all the values in column C (in this example values under column c is fixed but in the real situation it can be vary).

    how can i do this with excel VBA(macro) or is there any way to do this task using build in function in excel(if,match.......etc)

    I appreciate any help from you
    Attached Files Attached Files
    Last edited by rsami; 11-17-2011 at 02:55 AM. Reason: post title problem

  2. #2
    Registered User
    Join Date
    11-17-2011
    Location
    Sri lanka
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: macro or functions to identify same values in two columns

    i tried this task to do using if loops.but it's very difficult,
    please give me an instruction to do this

  3. #3
    Registered User
    Join Date
    11-17-2011
    Location
    Sri lanka
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: macro or functions to identify same values in two columns

    I'm very confused with this problem.please help me to solve this problem.
    i have attached the excel sheet too

  4. #4
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2003
    Posts
    4,168

    Re: macro or functions to identify same values in two columns

    hi, rsami, may be sort of that
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-17-2011
    Location
    Sri lanka
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: macro or functions to identify same values in two columns

    please help me if you know the answer

  6. #6
    Registered User
    Join Date
    11-17-2011
    Location
    Sri lanka
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: macro or functions to identify same values in two columns

    Quote Originally Posted by watersev View Post
    hi, rsami, may be sort of that
    Thanks very much.
    I'll try it and let you know
    thanks again

+ 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