P
PlanetAtkinson
Column A of sheet "data" of zap.xlsx has 10 data values in it, no header
Cell B1 of sheet Sheet1 of zot.xlsx contains the string "zap.xlsx"
Cell B2 of sheet Sheet2 of zot.xlsx contains the formula =COUNTA(INDIRECT(""&Sheet1!B1)&"data!$A:$A")
Instead of displaying the correct value, which is 10, Cell B2 displays 1.
It does not show an error message, it seems to work but gives the wrong answer.
How can I get the spreadsheet to find the number of rows in the first column of the other spreadsheet?
For what it's worth, another cell of Sheet2 contains the formula =COUNTA([zap.xlsx]data!$A:$A) and it displays the correct value, 10.
And another cell has the formula =INDIRECT(""&Sheet1!B1&"!A1") and it correctly displays the first data value correctly.
thanks in advance,
- Planet A.
Continue reading...
Cell B1 of sheet Sheet1 of zot.xlsx contains the string "zap.xlsx"
Cell B2 of sheet Sheet2 of zot.xlsx contains the formula =COUNTA(INDIRECT(""&Sheet1!B1)&"data!$A:$A")
Instead of displaying the correct value, which is 10, Cell B2 displays 1.
It does not show an error message, it seems to work but gives the wrong answer.
How can I get the spreadsheet to find the number of rows in the first column of the other spreadsheet?
For what it's worth, another cell of Sheet2 contains the formula =COUNTA([zap.xlsx]data!$A:$A) and it displays the correct value, 10.
And another cell has the formula =INDIRECT(""&Sheet1!B1&"!A1") and it correctly displays the first data value correctly.
thanks in advance,
- Planet A.
Continue reading...