Thread: combine 2 columns into 1 without knowing the size
View Single Post
 
Old 05-09-2017, 11:25 AM
NBVC's Avatar
NBVC NBVC is offline Windows 7 64bit Office 2007
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
If I understand correctly, you would need to add a count function and compare it to your row number and return blank if row number is greater than total count.

something lke:

=IF(ROWS($A$2:$A2)>COUNTA(YourList),"",YourCurrentFormula)
Reply With Quote