Results 1 to 2 of 2

Compare for matching names in Column A and calulate variance on a match

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2012
    Location
    NH
    MS-Off Ver
    Excel 2007
    Posts
    13

    Compare for matching names in Column A and calulate variance on a match

    I'm looking for a Macro or Function that will look for a match Column A 1:200 to Column A 220:500 and on a match insert the variance into Column B 520:800 that corresponds to the matched name. I've attached a small sample file. Find match for Column A220:A500 from A1:A200 and calculate the variance for the remaining columns and add to corresponding name in A:520:800.

    Thank You!!!
    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