madankum138
New member
- Joined
- Jan 23, 2013
- Messages
- 2
- Reaction score
- 0
- Points
- 0
wen type this formula i get an num error when ther is now data available in the cell ""=IF(ROWS(A$1:A36)>COUNTA('process standards LHS'!$E$5:$E$500),"",INDEX(('process standards LHS'!$E$5:$E$500),SMALL(IF('process standards LHS'!$E$5:$E$500<>"",ROW('process standards LHS'!$E$5:$E$500)-ROW('process standards LHS'!$E$5)+1),ROWS(A$1:A36))))""