Results 1 to 2 of 2

Column Z difference for repeats

Threaded View

  1. #1
    Registered User
    Join Date
    02-27-2014
    Location
    Little Rock, Arkansas
    MS-Off Ver
    Excel 2003
    Posts
    1

    Column Z difference for repeats

    In my worksheet Column Y contains multiple duplicates and Column Z contains values associated with each duplicate. I want to check every row in Column Y for multiple duplicates then find the difference between their associated Column Z values.

    ActiveSheet.Range("Y:Z").Duplicates Columns:=25, Header:= _ xlYes
    Last edited by Jim Em; 03-01-2014 at 06:14 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 12-09-2012, 09:00 PM
  2. Populate column with values from another column - no repeats, and no empties
    By badaboom55 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2010, 09:14 PM
  3. Formulae for: 4 most repeats,4 least repeats in a series of numbers
    By Sedge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2010, 04:56 AM
  4. Transpose 2nd column based on repeats in 1st column
    By GregJ in forum Excel General
    Replies: 4
    Last Post: 03-19-2009, 04:29 AM
  5. Replies: 3
    Last Post: 07-04-2008, 07:42 PM

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