Apr 09 2021 09:19 PM
Hi,
In the attached spreadsheet I have defined 'Data' as a range name for three numbers in a column A. I want to put the content of cell A2 into B2 using =Data (rather than =A2). However, the formula returns all the values of the range name Data instead of the value of A2 alone. How can I turn off the auto spill and just get the value that corresponds to row 2?
Thanks Alistair
PS I'm using Microsoft 365 Excel 16.47.1 on Mac OS 11.2.3
Apr 09 2021 10:09 PM
SolutionApr 09 2021 10:11 PM
Apr 09 2021 10:09 PM
Solution