+ Reply to Thread
Results 1 to 2 of 2

detect in each group the corresponding.

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,628

    detect in each group the corresponding.

    detect in each group the corresponding numbers
    we have 10 groups of 5 numbers and the macro will find if there is repetition in the same position
    and add the quantity, in the two groups of the two colors,
    https://www.excelforum.com/attachmen...1&d=1568057815
    Attached Files Attached Files

  2. #2
    Forum Contributor jomaor1's Avatar
    Join Date
    10-08-2018
    Location
    Brasil
    MS-Off Ver
    Excel 2016
    Posts
    175

    Re: detect in each group the corresponding.

    It has to be a Macro?

    Because you could just do the following:

    =COUNTIFS($Q5:$BW5;"x";$Q$3:$BW$3;BY$3)

    put it in cell "BY6"

    If you want it in a Macro, just tell the Macro to write it in BY6, and then copy to CC6 (or copy down too)
    John.

    "I excel at jumping to conclusions"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. detect in each group, and add quantity, and assemble the list of two colors,
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-08-2019, 09:41 AM
  2. detect in each group the number of times it was drawn
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-11-2019, 09:25 AM
  3. [SOLVED] please, detect the quantity of each group in the list
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-16-2019, 10:12 PM
  4. detect in each group with their suits
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2018, 10:17 PM
  5. detect in each group with their suits
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2018, 05:08 PM
  6. Replies: 14
    Last Post: 01-12-2017, 01:41 PM
  7. Replies: 3
    Last Post: 05-22-2016, 06:30 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