Options
Excel formula help!
allegiance
Member Posts: 25 ■□□□□□□□□□
in Off-Topic
Hi Guys,
Just needing some help with a couple of excel formulas I have. When they have no value, it appears as #NUM!. I want this to be blank.
The formulas are below:
First Column:
=INDEX(Range_text,SMALL(IF(TRANSPOSE(ROW(INDIRECT($F$1&":"&$F$2)))=Range_num,ROW(Range_num)-MIN(ROW(Range_num))+1,""),ROWS(D$4:$D8 )))
Second Column:
=INDEX(Range_num,SMALL(IF(TRANSPOSE(ROW(INDIRECT($F$1&":"&$F$2)))=Range_num,ROW(Range_num)-MIN(ROW(Range_num))+1,""),ROWS($D$4:E8 )))
Any help is appreciated! Thanks!
Just needing some help with a couple of excel formulas I have. When they have no value, it appears as #NUM!. I want this to be blank.
The formulas are below:
First Column:
=INDEX(Range_text,SMALL(IF(TRANSPOSE(ROW(INDIRECT($F$1&":"&$F$2)))=Range_num,ROW(Range_num)-MIN(ROW(Range_num))+1,""),ROWS(D$4:$D8 )))
Second Column:
=INDEX(Range_num,SMALL(IF(TRANSPOSE(ROW(INDIRECT($F$1&":"&$F$2)))=Range_num,ROW(Range_num)-MIN(ROW(Range_num))+1,""),ROWS($D$4:E8 )))
Any help is appreciated! Thanks!