LinkBack URL
About LinkBacks
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
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
cj48Try this and copy towards down
=LOOKUP(2,1/(ISTEXT(INDEX($BZ$48:$CG$56,MATCH($CI48,$AW$48:$AW$56,0),))*(LEN(INDEX($BZ$48:$CG$56,MATCH($CI48,$AW$48:$AW$56,0),))>0)),INDEX($BZ$48:$CG$56,MATCH($CI48,$AW$48:$AW$56,0),))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
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:
=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))
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)
Hello Siva and Ankur
thanks
both of your formulas working well.
thanks again
thilag
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks