+ Reply to Thread
Results 1 to 4 of 4

Searching through a range for a specific text and having it out into a different cell

  1. #1
    Registered User
    Join Date
    01-31-2017
    Location
    San Jose
    MS-Off Ver
    Excel 15.30 for Mac
    Posts
    9

    Question Searching through a range for a specific text and having it out into a different cell

    Hi!

    I have a massive 2000 odd list of of SKUs in different statuses that have Accepted and Invoiced information in different columns.

    I have attached to an example sheet with some raw data and how I'd like to have it shown at the bottom.

    Is it possible to do this without using macros? This way I can then take pieces of this and add this to my excel-fu.

    Thank you!!
    Attached Files Attached Files

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    2,178

    Re: Searching through a range for a specific text and having it out into a different cell

    Hi @laurigardner

    I suppose you make a mistake in your data in A3:A8. I use in first column the SKU number ordered AA1, AA2, ....

    Solution:

    The first two columns are the same

    Try in I14 and copy down and forward the following formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See the file where my solution is in G21:J28
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-31-2017
    Location
    San Jose
    MS-Off Ver
    Excel 15.30 for Mac
    Posts
    9

    Re: Searching through a range for a specific text and having it out into a different cell

    You beautiful beautiful person you!!

    Thank you!

    This saves me hours of work!

  4. #4
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    2,178

    Re: Searching through a range for a specific text and having it out into a different cell

    You are welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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