excel - If Cell in a range of values contains a type number print the corresponding header -
if given range of values in row in excel. each cell of particular may have contents of type number or may blank. there function/combinations of functions (non-vba) in excel print corresponding header of type number cell (with comma).
furthermore if cell not contain content of type number not print corresponding header , move on next cell. if it's last value in range, don't print comma @ end too. prefer somehow in 1 cell looks @ range of cells determines header print , ignore.
i'm using excel 2013
i without vba. here example below:
there simple way this, if first column number, or if live string starts comma if first column not number.
=if(isnumber(f5);f4&if(isnumber(g5);","&g4;"")&if(isnumber(h5);","&h4;"")&if(isnumber(i5);","&i4;"")&if(isnumber(j5);","&j4;"")&if(isnumber(k5);","&k4;"")&if(isnumber(l5);","&l4;""))
if random column contains first number formula have expand formula include second cell similar first isnumber statement in formula. placed @ end between 2 closing brackets such:
.....&if(isnumber(l5);","&l4;"");if(isnumber(g5);g4&if(isnumber(h5.......)
Comments
Post a Comment