+ Reply to Thread
Results 1 to 3 of 3

convert the sweepstakes to their palindrome pairs and identify the twin pairs.

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

    convert the sweepstakes to their palindrome pairs and identify the twin pairs.

    convert the sweepstakes to their palindrome pairs and identify the twin pairs. the macro will convert from the list of sweepstakes in its pair polindromo ex = 15 converts to 51
    https://www.excelforum.com/attachmen...1&d=1550573238
    Attached Files Attached Files

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: convert the sweepstakes to their palindrome pairs and identify the twin pairs.

    Hi

    If you don't really need really macro for it, please put into V6:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and drag it right/down as needed.
    then into AQ6 put:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and drag it right/down as needed.
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: convert the sweepstakes to their palindrome pairs and identify the twin pairs.

    hello koko, great job, my lottery (one of them) is keno 100/20
    there are in 00 to 99 45 pairs and their inverted or polindromos or capicuas, then in a lottery
    * example is drawn the 85 and does not come 58
    * or is drawn the 23 and is not the 32 or is one or is another numca the two together, except some pairs appear together in a draw, how could we create the filter
    * type or if you play 52 or 25 or numca the pair together
    * we have 45 pairs =
    01 02 03 04 05 06 07 08 09 12 13 14 15 16 17 18 19 23 24 25 26 27 28 29 34 35 36 37 38 39 45 46 47 48 49 56 57 58 59 67 68 69 78 79 89
    and has the other 45 inverted

+ 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. [SOLVED] locate in their positions pairs and odd pairs
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2018, 06:35 AM
  2. [SOLVED] Excel 2010 - Identify pairs of rows that have differences in 2 cells
    By Redfang87 in forum Excel General
    Replies: 1
    Last Post: 05-03-2017, 01:31 PM
  3. Identify pairs of values across columns
    By Brainman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-24-2017, 03:56 AM
  4. [SOLVED] Finding pairs
    By Johnny Image in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2012, 11:31 AM
  5. How to identify duplicates based on multiple cell pairs
    By dhendridge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2011, 05:06 AM
  6. Replies: 10
    Last Post: 01-05-2011, 03:26 AM
  7. [SOLVED] Locating and using twin pairs of numbers in a range
    By Carl in forum Excel General
    Replies: 6
    Last Post: 01-05-2006, 04: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