+ Reply to Thread
Results 1 to 9 of 9

Hook Front Back search

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

    Hook Front Back search

    Formula on G3 and I3 to summarise criteria on what is on g2 and i2

    The first and second results on g3 should be GAMA and g4 NANA and so on

    Find attached file
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,402

    Re: Hook Front Back search

    "Please" and "thank you" would not go amiss.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,740

    Re: Hook Front Back search

    @makinmomb: About time you tried to do some of this yourself!!!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,402

    Re: Hook Front Back search

    Quote Originally Posted by JohnTopley View Post
    @makinmomb: About time you tried to do some of this yourself!!!
    +1 to that, John!

  5. #5
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,695

    Re: Hook Front Back search

    Don't want to struggle , forum gives answers , time is a factor , + I am not a pro in excel

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,402

    Re: Hook Front Back search

    Quote Originally Posted by makinmomb View Post
    Don't want to struggle , forum gives answers , time is a factor , + I am not a pro in excel
    Real people give up a significant amount of their free time to help you here. I have not yet seen you even start to exert any effort, let alone struggle, in an attempt to meet them halfway. How do you think others here became so proficient in Excel?

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Hook Front Back search

    Agree with both the above, show us what you have tried so far...what worked, what didnt?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  8. #8
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,695

    Re: Hook Front Back search

    I have not tried anything , is complicated for me to try , that is why i use this forum

  9. #9
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,883

    Re: Hook Front Back search

    What are you working with, makinmomb?
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ 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] letter hook front and back
    By makinmomb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-08-2017, 10:13 AM
  2. [SOLVED] Vowel hook search
    By makinmomb in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-26-2016, 03:10 PM
  3. [SOLVED] Using Find to search from back to front in a range
    By TechKnowledge in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-26-2016, 07:03 PM
  4. Replies: 2
    Last Post: 06-20-2015, 06:11 AM
  5. How Would I Add * Mark to Front and Back of All Cells?
    By JannaMay17 in forum Excel General
    Replies: 4
    Last Post: 03-31-2012, 03:46 AM
  6. Access Front-end, Excel Back-end
    By dreicer_Jarr in forum Excel General
    Replies: 3
    Last Post: 03-08-2010, 08:07 PM
  7. How can we link front-end to back-end using UNC
    By joe41 in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2009, 11:23 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