+ Reply to Thread
Results 1 to 4 of 4

Formula to extract text from a cell and copy into a table.

  1. #1
    Registered User
    Join Date
    04-23-2018
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    6

    Formula to extract text from a cell and copy into a table.

    Hi,

    Im having a problem with a formula in Excel. I got a large workbook with different values which is copied over to a table when you choose spesific dates and name. But i can't get the comments to transfer automaticly. I want to get the comments from each person automaticly filled in at the correct date.

    I will post a example of the workbook and i hope someone can help me.

    Thank you in advanced,

    Regards Thuns
    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 (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Formula to extract text from a cell and copy into a table.

    Please manually mock up what you want it to look like and post the attachment again - otherwise, it's just guesswork and that wastes time.
    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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-23-2018
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    6

    Re: Formula to extract text from a cell and copy into a table.

    Thanks for the reply!

    I have now mocked up an example of a finished report. The comments have been copied from the table on the left to the table on the right. So what the person wrote on 01.03.18 is copied to 01.03.18 in the table on the right.

    Does this make sense?

    Regards Thuns
    Attached Files Attached Files

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

    Re: Formula to extract text from a cell and copy into a table.

    As long as your names and date formats in the main table are consistent with the summary table, this will work:

    =LOOKUP(2,1/((RTabell[Fullt navn *]=$M$6)*(RTabell[Date]=K9)),RTabell[[Kommentar ]])

    or maybe, for your Norwegian locale:

    =LOOKUP(2;1/((RTabell[Fullt navn *]=$M$6)*(RTabell[Date]=K9));RTabell[[Kommentar ]])

+ 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] Extract a formula from a table to calculate another cell
    By Nights in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2015, 05:54 AM
  2. [SOLVED] Formula to extract Registration Number (ABN) from text in a cell
    By &Roo in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-20-2015, 05:39 AM
  3. Extract and Copy Part of Text String From one cell to another
    By Chica SM in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-22-2014, 10:39 AM
  4. Formula to extract particular range of text from a cell
    By faizzsheikh in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-29-2014, 02:02 PM
  5. [SOLVED] Extract/Copy Text from Cell, and insert that text in a new row below
    By jamesoneill in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-07-2013, 09:06 AM
  6. [SOLVED] Formula to Extract Numbers from Text Cell
    By MHamid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-03-2012, 04:08 PM
  7. Replies: 0
    Last Post: 05-05-2011, 06:41 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1