+ Reply to Thread
Results 1 to 4 of 4

Formula to extract row / right last texts for given texts

  1. 12-30-2015, 01:41 AM #1
    thilag
    thilag is offline
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Formula to extract row / right last texts for given texts

    Hello Friends

    Please find the attached file (Formula to extract row or right last texts for given texts 301215.xlsx).

    I want to plot the extreme right text for the given input letter in light yellow cells.

    thanks in advance

    thilag
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-30-2015, 01:54 AM #2
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Formula to extract row / right last texts for given texts

    cj48 
    Please Login or Register  to view this content.
    Try this and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  3. 12-30-2015, 02:03 AM #3
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: Formula to extract row / right last texts for given texts

    or try

    CJ48=LOOKUP(2,1/(OFFSET($AW$47,MATCH(CI48,$AW$48:$AW$56,0),1,1,36)<>""),OFFSET($AW$47,MATCH(CI48,$AW$48:$AW$56,0),1,1,36))

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Reply With QuoteRegister To Reply
  4. 12-30-2015, 02:51 AM #4
    thilag
    thilag is offline
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Re: Formula to extract row / right last texts for given texts

    Hello Siva and Ankur

    thanks

    both of your formulas working well.

    thanks again

    thilag
    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. Assemble formula from texts in other cells
    By 13gentj in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-19-2014, 11:00 PM
  2. [SOLVED] To average cells included texts - how to ignore texts in those cells - help please
    By PrayoonD in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-23-2014, 12:32 PM
  3. [SOLVED] To extract texts from a cell
    By Dewdrop in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-25-2014, 10:26 AM
  4. Bold few texts in a sentence which has a formula...
    By Shradharani in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-18-2013, 06:07 AM
  5. Bold few texts in a sentence which has a formula
    By Shradharani in forum Excel General
    Replies: 5
    Last Post: 10-11-2013, 03:56 PM
  6. [SOLVED] Bold few texts in a sentence which has a formula
    By Shradharani in forum Excel General
    Replies: 1
    Last Post: 10-10-2013, 12:34 PM
  7. Create a Formula where using different texts to display a value
    By garethdurbridge in forum Excel General
    Replies: 4
    Last Post: 01-11-2010, 11:06 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