+ Reply to Thread
Results 1 to 18 of 18

2 LETTERS puller for gaming

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,597

    2 LETTERS puller for gaming

    Say I have the word AIRDATES that needs to be looked into the word SATIRE
    and then pull the answer which is AD

    I have down the 4 manually in the attached file

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,597

    Re: 2 LETTERS puller for gaming

    Logically you are telling the formula to Minus Text AIRDATES Minus SATIRE

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,597

    Re: 2 LETTERS puller for gaming

    Formula on A1 for dragging downwards

  4. #4
    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: 2 LETTERS puller for gaming

    Hi,

    You'll have to explain exactly what you're wanting. I'm not clear which is your data and which your results and how you move from one to the other. Describe your thought process that enables you to arrive at the results referring to specific cells and any rules you are applying.

    Am I correct in thinking that you are also processing anagrams , i.e. SATIRE is a partial anagram of AIRDATES
    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.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: 2 LETTERS puller for gaming

    Hi there. Try this out.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  6. #6
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: 2 LETTERS puller for gaming

    A1=substitute(substitute(substitute(substitute(substitute(substitute(substitute(substitute(substitute(substitute($b1,mid($f$1,1,1),"",1),mid($f$1,2,1),"",1),mid($f$1,3,1),"",1),mid($f$1,4,1),"",1),mid($f$1,5,1),"",1),mid($f$1,6,1),"",1),mid($f$1,7,1),"",1),mid($f$1,8,1),"",1),mid($f$1,9,1),"",1),mid($f$1,10,1),"",1)
    try this and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: 2 LETTERS puller for gaming

    One way:

    Please Login or Register  to view this content.
    Row\Col
    A
    B
    C
    D
    1
    DA AIRDATES SATIRE A1: =MM(B1, C$1)
    2
    DA DATARIES
    3
    DA RADIATES
    4
    HA HETAIRAS
    Entia non sunt multiplicanda sine necessitate

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: 2 LETTERS puller for gaming

    Hi. Try this out...
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,597

    Re: 2 LETTERS puller for gaming

    GLENN your answer is correct but needs to go onto A1 , not sure if it can write as AD instead of DA

    Richard is the STEM ( SATIRE ) minus the actual word ( AIRDATE ) = AD , i hope this is now clear

  10. #10
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,597

    Re: 2 LETTERS puller for gaming

    SHG i admires your too , if you could send it as a file please

  11. #11
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: 2 LETTERS puller for gaming

    Row\Col
    A
    B
    C
    D
    1
    AD AIRDATES SATIRE A1: =MM(B1, C$1)
    2
    AD DATARIES
    3
    AD RADIATES
    4
    AH HETAIRAS


    Please Login or Register  to view this content.

  12. #12
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,597

    Re: 2 LETTERS puller for gaming

    I have taken SHG solution , while leaving the thread open in case someone finds a way through formula
    I think it will be difficult to swap by alpha formula wise

  13. #13
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: 2 LETTERS puller for gaming

    In response to your PM:

    Copy the code from the post

    In Excel, do Alt+F11 to open the VBE

    Insert > Module

    Paste in the window that opens

    Do Alt+Q to return to Excel.

  14. #14
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,597

    Re: 2 LETTERS puller for gaming

    Thanks SHG got it correct , I re did it

  15. #15
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: 2 LETTERS puller for gaming

    You're welcome.

  16. #16
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: 2 LETTERS puller for gaming

    It can be done by formula... but. Stick with SHG's solution.
    Attached Files Attached Files

  17. #17
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,597

    Re: 2 LETTERS puller for gaming

    wow non vba , admire the length of the formula , thanks glenn ,
    I will keep this too along with SHG file already started using
    Last edited by makinmomb; 01-04-2015 at 04:44 AM.

  18. #18
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,597

    Re: 2 LETTERS puller for gaming

    If I wrap the formula its not even visible , thus i used a notepad ,
    this is how long it is and does the work just as the macro of shj

    Please Login or Register  to view this content.
    Last edited by makinmomb; 01-04-2015 at 04:54 AM.

+ 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] stock reconcile variance puller
    By makinmomb in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-20-2014, 01:23 PM
  2. Replies: 4
    Last Post: 06-15-2014, 11:49 AM
  3. Excel for Remote Gaming
    By leoth in forum Excel General
    Replies: 0
    Last Post: 01-31-2014, 02:58 PM
  4. Gaming Macro
    By markrennolds in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2013, 01:41 PM
  5. [SOLVED] Reading the last 2 letters in a combobox value and enter those 2 letters into column
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-26-2013, 09:26 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