+ Reply to Thread
Results 1 to 3 of 3

find letter and position in the matrix of the 10 strings of 6 digits.

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

    find letter and position in the matrix of the 10 strings of 6 digits.

    find letter and position in the matrix of the 10 strings of 6 digits,
    is a list of example, I will put new draws every week the amcro has to do automatic, the draws with repetition of digits ex = 223 will not work know this.
    * just for singles draws ok. first locate the letters after the positions, please
    https://www.excelforum.com/attachmen...1&d=1545654422
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: find letter and position in the matrix of the 10 strings of 6 digits.

    ARRAY formula in E7 then drag down.
    Please Login or Register  to view this content.
    In F7 and dragged across upto K15
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

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

    Re: find letter and position in the matrix of the 10 strings of 6 digits.

    Okay,KVSRINI very good job, now second step,
    * see the frequencies in descending order from the highest number of times to the lowest
    * of each string
    * ex = D
    ******** AND
    ....
    *** F
    * WHERE D WAS THE LARGEST AND F LOWER IN THE LIST ORDER, PLEASE
    * PUTTING A LIST TO THE SIDE

+ 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] How to extract a text if you know the position of the first letter and letter number
    By zanshin777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2018, 05:00 AM
  2. [SOLVED] Find the strings of only the last digits of the numbers in the 5 sectors, please!
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 41
    Last Post: 04-16-2017, 08:46 AM
  3. Replies: 2
    Last Post: 03-07-2013, 02:34 AM
  4. [SOLVED] Macro to find letter strings within a list
    By as115 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-09-2013, 10:52 AM
  5. Find position in matrix (not array)
    By Coaster in forum Excel General
    Replies: 5
    Last Post: 11-14-2011, 01:26 PM
  6. Strings - Find position of the nth occurrence
    By efernandes67 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2009, 05:46 PM
  7. Replies: 7
    Last Post: 02-19-2007, 12:17 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