Reference functions convert empty cells to zero
Posted by Derek on June 27, 2001 3:22 AM
All the Excel reference functions (such as INDEX) return the value of an empty cell as zero. You cannot then tell the difference between data where zero has been entered and data which has been left blank. Of course it would be possible to convert the data (using ISBLANK) into a format where the blanks are identified, before calling INDEX. However if there is a large amount of data this seems a bit of a sledgehammer to crack a nut. Can anyone think of another way around this?