Results 1 to 15 of 15

Complecate Macro to search value of intersect Rows and Columns with conditions

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-15-2012
    Location
    beirut
    MS-Off Ver
    Excel 2007
    Posts
    212

    Complecate Macro to search value of intersect Rows and Columns with conditions

    Dear All : i have sheet contain in Column A Number of Exams and in the first Row the Name of Students ( more 50 students name ) and in the second Row the name of Classes and the Range ( B3:GG) is Marks of Student. and in Column Q i have the Number of some Exams and in cell R2 the Student Name .

    what i need a macro Littel Complicated , that search each Number of Exams in Column Q with Column A at the same time search the Name of Student that exist in Cell R2 with Row 1 , then find the first and Second and third intersect of these searches and put the result in Column S and U , also find the the Classes of the Marks that found and put the result in Column R and T.

    please see attached file.

    Thanks in Advance
    Attached Files Attached Files

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