I have one worksheet in a workbook that contains several cells with drop-down lists, separated by rows and columns. On a separate worksheet I have created a column equal to the values contained in the drop-down cells mentioned above. If the drop-down cell contains a blank, it gets copied as a Zero in the column I've made. I don't want Zeroes, so I have used a few different formulas to remove the Zero, all involving the null string "". This makes my column have several cells appearing to be empty. Then in the column next to the copied data, with the null strings, I've used another array formula to eliminate the blank cells using iferror, index match, and istext. This is not working because the cells with the null string is not actually blank when it contains the null string "".
Can someone tell me how to take a column of cells that contains null strings and make a new column that eliminates the null strings?
Thanks, I hope I am making sense here.