Hello, I am struggling to create a formula that would satisfy some dynamic assumptions. Here is what it looks like. I would appreciate your comments.
Formula.xlsx
Hello, I am struggling to create a formula that would satisfy some dynamic assumptions. Here is what it looks like. I would appreciate your comments.
Formula.xlsx
Here's an option, In B7 copied across and down
=IFERROR(IF(COLUMNS($A$1:A$1)-MATCH("Launch",$B7:$I7,0)<0,"",INDEX($B$4:$I$4, COLUMNS($A$1:A$1)-MATCH("Launch",$B7:$I7,0)+1)),"")
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
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
THANK YOU ChemistB and Speshul
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks