LinkBack URL
About LinkBacks
Extract the number from the left cell to matching word
Extract the number from the left cell to matching word
Extract the number from the left cell to matching word
In B5 copied to the right
Formula:
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you for the response. Since there are more results for matching, how to extend the answers ?
I have slightly modified the formula of ChemistB
Since column A is free, search range is A5:A6. it can be changed.
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thank you. Please edit the formula without referencing row 5 data.
Row 5 is the result.
Changed formula.
=IFERROR(INDEX($B$2:$U$2, AGGREGATE(15, 6,(COLUMN($B$2:$U$2)-COLUMN($B$1))/SEARCH("*"&$A$5:$A$6&"*",$B$2:$U$2),COLUMNS($B7:B7))),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks