+ Reply to Thread
Results 1 to 3 of 3

detect the numbers on each draw line we both sectors and add the amount

  1. 09-28-2019, 11:03 AM #1
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    detect the numbers on each draw line we both sectors and add the amount

    detect the numbers on each draw line we both sectors
    and add the amount
    https://www.excelforum.com/attachmen...1&d=1569683022
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-28-2019, 11:26 AM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: detect the numbers on each draw line we both sectors and add the amount

    Hi

    In Q6 copied to Q6:AF1865 & AH6:AW1865
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    and in AG6 copied down to row 1865
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    ...and similarly for AX6
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 09-29-2019, 09:09 AM #3
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: detect the numbers on each draw line we both sectors and add the amount

    hello, RICHARD, ok conglatulations, correct, thank you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] detect the upper (+1) and lower (-1) adjacent of the draw line reference.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2019, 06:27 PM
  2. [SOLVED] Only detect matching complete trios on each draw line.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-15-2019, 05:08 PM
  3. [SOLVED] detect each corresponding number of the draw line.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-24-2019, 11:23 AM
  4. 198/5000 detect the repeated and absent numbers always from the last draw to the next.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2019, 08:54 AM
  5. [SOLVED] detect the numbers of the two sectors *
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2019, 08:32 AM
  6. in each draw line * detect the two empty quadruples
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2019, 08:12 AM
  7. please!find out how many times two numbers appear together in a draw line.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2018, 06:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1