Forum Discussion
Palazques
Apr 26, 2023Copper Contributor
Entered value in range returns multiple values
I am trying to create something so I don't have to go looking around for all the data when a value is entered in a cell. For example: Say there is a range of cells, when a numerical value is entered...
OliverScheurich
Apr 26, 2023Gold Contributor
=IF(REDUCE(0,TOCOL(B2:C8),LAMBDA(ini,arr,N(ISNUMBER(arr))+ini)),TEXTJOIN(" - ", , J1,G7,A7),"")You can try this formula. If there is at least one cell with a number in range B2:C8 then the TEXTJOIN is returned in cell D4 otherwise D4 is blank.