Results 1 to 2 of 2

remove duplicated row and increase weight columns with vba

Threaded View

  1. #1
    Registered User
    Join Date
    12-26-2015
    Location
    beirut
    MS-Off Ver
    2010
    Posts
    6

    remove duplicated row and increase weight columns with vba

    I'm trying to add a weight for source and target cell...so I do this :


         .Resize(, 4) = Array("Source", "Target", "Label", "Weight")
            .........
    
            Range(sStartingCellOutput).Offset(lRowOffset, lColOffset).Resize(1,4).Value = _
            Array(sq(lUser_1, 2), sqq(lUser_2), rTopic.Value,1)
    then the result is like this :

     
    Source ,Target,Label,Weight
    2955,7733,1,1
    7733,2955,1,1
    2961,6498,2,1
    6498,2961,2,1
    2961,2962,3,1
    2961,2962,3,1
    2962,2961,3,1
    2962,2961,3,1
    But I didn't want to show the duplicates row (source and target) i want to remove the duplicate and increase the weight ...
    like this :

    Source,Target,Label,Weight
    2955,7733,1,1
    7733,2955,1,1
    2961,6498,2,1
    6498,2961,2,1
    2961,2962,3,2
    2962,2961,3,2


    any help for that ??

    thanks
    Last edited by fifohsn; 12-26-2015 at 09:34 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove many unwanted/duplicated styles
    By Vaslo in forum Excel General
    Replies: 9
    Last Post: 11-24-2014, 12:54 AM
  2. Replies: 26
    Last Post: 07-29-2014, 06:38 PM
  3. Remove Duplicated items in combo box
    By FRIEL in forum Excel General
    Replies: 11
    Last Post: 12-03-2012, 04:26 PM
  4. How to remove semi-duplicated text
    By variatsioon in forum Excel General
    Replies: 2
    Last Post: 11-05-2010, 12:49 PM
  5. Remove Combobox Duplicated items
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2009, 02:35 AM
  6. Replies: 1
    Last Post: 10-16-2005, 08:05 AM
  7. Remove ALL duplicated records, leaving behind NONE
    By Christopher Dawes in forum Excel General
    Replies: 2
    Last Post: 06-06-2005, 07:05 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