Forum Discussion

JGDANIEL's avatar
JGDANIEL
Copper Contributor
Mar 07, 2020
Solved

ROW Function Criteria Not Accepted

Hi everyone,   I'm trying to get the ROW() function to accept the values written in different cells.   The following formula works and yields an array: =ROW(1:6)     However, I would like to ...
excel
ExcelExciting's avatar
ExcelExciting
MVP
Mar 07, 2020

HI JGDANIEL

 

Please see the formula should be constructed as below

 

=ROW(INDIRECT(INDIRECT(CONCAT("A",1))&":"&INDIRECT(CONCAT("B",1))))

 

You need to add indirect again to convert that text string into reference

 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

 

Resources