=OFFSET(INDEX(sheet2E$5:$MI$5,SMALL(IF(sheet2E5:MH5="yes",COLUMN(E5:I5)-COLUMN(sheet2E5)+1),1)),-2,0,1,1)
I used the above formula to find a month with a "yes" in order to indicate a barbie doll was sold. I need to offset ONLY when a yes is present, but i am currently struggling to come up with a formula that works properly passed the first instance of "yes". My goal is to solely offset from "yes" cells, and to completely ignore months without orders. The top chart is on one page and the bottom two charts are linking to the top chart, but they are on a different page. So for each instance, the quantity, buy price, quantity, sell price and total should be displayed under the instance 1 header. Months with no orders should not appear so that each instance only contains an order. (Example: if there is an order in June (M5) but not July (N5), but there is one in August (Q5), instance 1 will display the June order stats while instance 2 will display the August order stats). Thanks in advance!
Bookmarks