Results 1 to 7 of 7

Sorting cell content based on text within text?

Threaded View

vendo_23 Sorting cell content based on... 11-18-2020, 03:41 AM
bebo021999 Re: Sorting cell content... 11-18-2020, 04:29 AM
vendo_23 Re: Sorting cell content... 11-18-2020, 06:11 AM
vendo_23 Re: Sorting cell content... 11-19-2020, 09:52 AM
bebo021999 Re: Sorting cell content... 11-19-2020, 09:19 PM
vendo_23 Re: Sorting cell content... 11-24-2020, 02:28 AM
kvsrinivasamurthy Re: Sorting cell content... 11-20-2020, 09:48 AM
  1. #1
    Registered User
    Join Date
    11-18-2020
    Location
    USA
    MS-Off Ver
    Office 365 MSO (16.0.13231.20110) 32bit
    Posts
    4

    Sorting cell content based on text within text?

    Hi, I've created an example spreadsheet of what I'm looking to do.

    I need the contents of Column A to be sorted (Example output, Column C), based on the input text contained within Column B.

    I am still pretty new to excel and haven't been able to figure this out. I've tried XLOOKUP, but that doesn't seem to do what I need here.


    Column B contains a string of text that exists in each cell on Column A. "dll" exists in A3, for example. What I want is to basically sort A2, A3, and A4 using B2, B3 and B4 as a guide. This would be output as seen on Column C.



    Hopefully this is possible, thank you for any help you can provide!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cell Value Based On Multiple Text Content
    By sultanmimar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-03-2019, 03:06 AM
  2. [SOLVED] VLOOKUP to return specific text based on content of other cell
    By bundyanimal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2018, 01:18 AM
  3. [SOLVED] remove cell content based on another cells text
    By toneNFFC in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-20-2015, 10:13 AM
  4. [SOLVED] remove cell content based on another cells text
    By toneNFFC in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-13-2015, 08:02 AM
  5. How do you make a text box appear/disappear based on cell content?
    By gmac1985 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2015, 12:06 AM
  6. sorting text from one cell into 3 other cells based on text criteria
    By steik in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2014, 06:35 PM
  7. Changing the text on button based on cell content
    By a94andwi in forum Excel General
    Replies: 1
    Last Post: 06-11-2009, 12:58 PM

Tags for this Thread

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