Create list of cell addresses contained in a range

Published: 14/11/2019
Create list of cell addresses contained in a range
Source: WEBAPPS.STACKEXCHANGE.COM

I'm looking for a single arrayformula to convert a specified range, such as B2:D4 , into a list of addresses (not values!) contained in that range, in this case B2,B3,B4,C2,C3,C4,D2,D3,D4 . Attempts so far Google didn't come up with useful results. I have tried to count through the array, and are able to extract two list of numbers corresponding to the row and column numbers, but have failed to

Read more
Related news
Comment
FACEBOOK