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![]()
Please Login or Register to view this content.
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:
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)
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)
Bookmarks