+ Reply to Thread
Results 1 to 5 of 5

Find Data within two columns

  1. 01-11-2023, 10:50 AM #1
    BEN_RUBAT_91
    BEN_RUBAT_91 is offline
    Registered User
    Join Date
    01-11-2023
    Location
    Switzerland
    MS-Off Ver
    365
    Posts
    2

    Find Data within two columns

    Hello

    I have a file that give data as per attached.

    I want to extract in a new column of the customs ID that are in column A. I know which one in the sequence is the customs ID as the column B Hold the Service Order type in the same sequence,


    Thanks a lot for your help

    BenShipmentOrderDataReport-20230111-153329.xlsx
    Reply With QuoteRegister To Reply
  2. 01-11-2023, 11:26 AM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Find Data within two columns

    How about
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 01-11-2023, 11:34 AM #3
    JohnTopley
    JohnTopley is online now
    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
    28,207

    Re: Find Data within two columns 

    Please Login or Register  to view this content.
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  4. 01-11-2023, 11:37 AM #4
    BEN_RUBAT_91
    BEN_RUBAT_91 is offline
    Registered User
    Join Date
    01-11-2023
    Location
    Switzerland
    MS-Off Ver
    365
    Posts
    2

    Re: Find Data within two columns

    Quote Originally Posted by Fluff13 View Post
    How about
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Great, it works

    thanks
    Reply With QuoteRegister To Reply
  5. 01-11-2023, 11:39 AM #5
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Find Data within two columns

    Glad to help & thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to Find Matching Data from 1 Column against Multiple Columns Without Losing Data?
    By JJL4677 in forum Excel General
    Replies: 4
    Last Post: 02-03-2021, 02:54 PM
  2. compare columns to find data
    By Rhemo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-15-2018, 09:42 AM
  3. Find two columns Matching Data & columns data related lookup data
    By krishna8080 in forum Office 365
    Replies: 1
    Last Post: 11-09-2018, 04:40 PM
  4. Find data based off unique identifiers and return only columns showing data
    By yomamma34 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-23-2014, 05:03 PM
  5. [SOLVED] How to find data for Salesperson from different columns
    By sratkins in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-02-2012, 11:02 AM
  6. How-to find matching data in two columns and then comparing data next to them
    By yanickr1973 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-30-2012, 02:40 PM
  7. Find unique data across two columns
    By athlon38 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-13-2012, 02:26 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1