Re: Filling a matrix based on coordinates

2022-05-23 Thread Regina Henschel
Hi John, john silver schrieb am 23.05.2022 um 14:09: I'm trying to fill a matrix based on the coordinates of each cell. In the formula cell I got"=CONCATENATE("RS-";TEXT(COLUMN();"##");TEXT(ROW()+;"##"))" That looks wrong. The formula cell must not use anything from the final two-dimensional

Filling a matrix based on coordinates

2022-05-23 Thread john silver
I'm trying to fill a matrix based on the coordinates of each cell. In the formula cell I got"=CONCATENATE("RS-";TEXT(COLUMN();"##");TEXT(ROW()+;"##"))" But when I try to use the Multiple operations most of the cells end up containing the exact same value. ---