+ Reply to Thread
Results 1 to 6 of 6

To pull a data from the excel

  1. 04-08-2024, 07:18 AM #1
    Ponmudi Aloysius
    Ponmudi Aloysius is offline
    Registered User
    Join Date
    03-12-2024
    Location
    chennai, India
    MS-Off Ver
    Microsoft 360
    Posts
    4

    To pull a data from the excel

    Good Dear All,

    I want to extract a details from a table by excluding the unique details from the other table

    LIC-1168 22-01-2024 30-04-2024 LIC-1331
    LIC-1169 22-01-2024 30-04-2024 LIC-1345
    LIC-1170 22-01-2024 30-04-2024 LIC-1349
    LIC-1172 22-01-2024 30-04-2024 LIC-1350
    LIC-1352 22-01-2024 30-04-2024 LIC-1352 I WANT OUTPUT EXCLUDING THESE DATA FROM TABLE 2
    LIC-1354 20-02-2024 30-04-2024 LIC-1354
    TABLE1 TABLE2




    OUT PUT
    LIC-1168 22-01-2024 30-04-2024
    LIC-1169 22-01-2024 30-04-2024
    LIC-1170 22-01-2024 30-04-2024
    LIC-1172 22-01-2024 30-04-2024
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-08-2024, 07:26 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,469

    Re: To pull a data from the excel

    Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 04-08-2024, 07:37 AM #3
    Ponmudi Aloysius
    Ponmudi Aloysius is offline
    Registered User
    Join Date
    03-12-2024
    Location
    chennai, India
    MS-Off Ver
    Microsoft 360
    Posts
    4

    Re: To pull a data from the excel

    I am not getting the formula working, pls download the excel and in that you find details correctly
    Reply With QuoteRegister To Reply
  4. 04-08-2024, 08:09 AM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,469

    Re: To pull a data from the excel

    Ok, updated file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 04-09-2024, 03:17 AM #5
    josephteh
    josephteh is offline
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,065

    Re: To pull a data from the excel

    Try, =FILTER(A1:C6,A1:A6<>IFERROR(XLOOKUP(A1:A6,E1:E6,E1:E6,0),FALSE))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 04-09-2024, 04:26 AM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,469

    Re: To pull a data from the excel

    Is this resolved now?



    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    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. Pull info from PDF, write to cells in excel, send excel data to word document
    By bhollehday in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2016, 02:00 PM
  2. [SOLVED] Excel does not pull value from the cell - appears to pull formula
    By enjoyexcel in forum Excel General
    Replies: 2
    Last Post: 01-06-2015, 11:42 AM
  3. Vlookup query : How to pull data from raw excel files into a master excel file?
    By jamesjamesiata in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2013, 06:26 AM
  4. [SOLVED] Pull Data from once excel sheet to another
    By dt_org in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-06-2013, 12:43 AM
  5. Looping data of excel sheet to pull data of web with login screen
    By Lisa4legin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2012, 06:51 PM
  6. Use of Excel to pull data from database daily, posting new data below older data
    By Ishness in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-09-2011, 10:08 AM
  7. Pull web data to excel
    By sujittalukder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2007, 11:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1