Hi guys, having trouble with the following formula.
=IFERROR(OFFSET(INDIRECT("A"&2),INDEX( MATCH(1,(--(INDIRECT("A"&2):INDIRECT("A"&10)<>"")),0),1)-1,0),"")
Obviously with this formula i can find the first cell between cells A2 and A10 that is not blank and say enter it in cell C1. Though what I need to do is modify this slightly so that it will pick up then 2nd and 3rd cells in the range between A2 and A10 that is not blank also and post these in cells D1,E1,F1...
I have attached a demo for what I need. So cell C1 is correct answer but cell D1 should be PRODUCT F and cell E1 should be PRODUCT H.
Any help greatly apprectiated.
Thanks,
Kelly.
Bookmarks