Transpose & Blank Issues

[Data123]

Hi when I use the =TRANSPOSE formula (see pic) I often get some blank rows. Those cells representing the blank rows have no formula. Meaning the formula is gone for those missing rows and this is what is causing it. I have created a new workbook and the same issue occurs again. I have verified those stocks have data.

Also, but less important why is the formula grayed out for the cell shown in the pic?

Oh one other question, for some reason when I get these blank areas and I try to refresh the data I the get many more blanks with the statement #SPILL! (see other pic).

 

[Peter_SSs]

Like this?

Data123 Mr Excel Help_1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
7	iShares:Tr Fl Rate Bond (ARCX:TFLO)	$ 50.56	$ 50.56	$ 50.55	$ 50.52	$ 50.52	$ 50.50	$ 50.50	$ 50.70	$ 50.68	$ 50.68
Sheet4

Cell Formulas
Range	Formula
B7:K7	B7	=TAKE(TRANSPOSE(SORT(STOCKHISTORY(A7, TODAY()-14, TODAY(),0,0,0,1),,-1)),-1)
Dynamic array formulas.

 

[Data123]

Like this?
****Yes thank you so much!!!!! You are an Excel Ninja Master!

 

[Peter_SSs]

You are welcome.

When quoting a post (or part of it) and adding your response, please do so outside of the actual quote, not inside. I previously fixed it for you in post #20 as I thought it must have been an accident but the same thing has happened in post 22. The way you have done it makes it look to other readers as if I had posted the "****Yes thank you so much!!!!! You are an Excel Ninja Master!"

 

[Data123]

You are welcome.

When quoting a post (or part of it) and adding your response, please do so outside of the actual quote, not inside. I previously fixed it for you in post #20 as I thought it must have been an accident but the same thing has happened in post 22. The way you have done it makes it look to other readers as if I had posted the "****Yes thank you so much!!!!! You are an Excel Ninja Master!"

Will do sorry about that. I noticed in my last several replies my reply cursor was put into the tan color of your last response. I clicked enter several times only to stay within the tan color. I am on my phone now and after clicking reply have no issue like before. Will make sure to keep an eye out for it. Thanks for pointing it out.

 

[Peter_SSs]

Cheers.