In A1,
= ADDRESS( MOD( INT(COLUMN() - 1) / 26, 10) + 1, INT( (COLUMN() + 259) /260), 4)
& ADDRESS(ROW(), MOD(COLUMN()-1, 26) + 1, 4)
Copy down to A10 and across to column IYZ.
In A1,
= ADDRESS( MOD( INT(COLUMN() - 1) / 26, 10) + 1, INT( (COLUMN() + 259) /260), 4)
& ADDRESS(ROW(), MOD(COLUMN()-1, 26) + 1, 4)
Copy down to A10 and across to column IYZ.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks