Results 1 to 21 of 21

Macro to Match Items in Col C

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2024
    Posts
    2,873

    Macro to Match Items in Col C

    I have values in Col C and need the values that match to be deleted as follows


    1) Where there is a value in Col C with say a positive value eg 2150 and there is a single value that is negative -2150 then the rows containing these values are to be deleted (I have highlighted all the items in yellow where the positive value and negative values equal to zero). I have also put numbers next to each of the yellow items that match off

    2) Where there are several values in Col C that sums to say R 925.45 and there are several other values that sums up to these but they are opposite in value for e.g. if the sum of several values is say R 25000 and there are negative values adding up to- R 25000 then these must be deleted. I have shown these with different colours where several say negative values sums up to several positive values and vice versa



    It would be appreciated if someone could kindly assist me
    Last edited by Howardc1001; 04-29-2020 at 02:52 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to delete certain items then count remaining items #2
    By elgato74 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-21-2019, 02:26 PM
  2. [SOLVED] Macro to delete certain items then count remaining items
    By elgato74 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-14-2019, 03:20 PM
  3. Replies: 2
    Last Post: 11-17-2016, 06:37 AM
  4. [SOLVED] Need to count items in column that match multiple data items
    By bclucas55 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-27-2014, 10:03 AM
  5. macro to filter all items in Autofilter except 2+ items
    By DanRiverBrew in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2013, 09:15 PM
  6. [SOLVED] One to many items match
    By Pavan_Jack in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-30-2012, 01:16 PM
  7. [SOLVED] Match Items
    By vharjani3 in forum Excel General
    Replies: 17
    Last Post: 06-04-2012, 09:14 AM

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